G
Guest
Hi there
I have a problem that I havn't been able to sort through tried various but haven't come up with solution.
I have a 'simple' inventory db. Tracking parts coming in and useage. Requirements are to not issue parts for a Sale unless all parts on sale are available (in stock). I have this requirement working via a cmd button on the 'sale' basically behind the cmd button is code whic
For that sal
1) writes to a temp table parts that could be issued because stock is avialable.
2) count the above record
3) count the number of records on tblsaledetail for that sal
4) if #records in temp table = #records on sale then all parts are in stock and I can issue - I change a flag to true and write the itemdetails table to track store parts used
The above is working fine. But it is slow as currently the user has to go to each individual 'sale' and press the button in order to see if the 'Sale' is good to go
What I have done also is if the statement 4 above is false all parts aren't available I've updated a HOLD table with the date ON hold
Now my problem. What I'd like to do is have a button - not related to a specific sale record - that will go and do something like the above mentioned qry's to tell me what Sales I can take off of hold. i.e. when new stock is recieved, press i.e. a Stock Check button. it all the parts on the sale are there enter current date into the dateoff hold field. This will allow me to give them a report to tell them what sales they can go an issue
basically my code is grouped and the where clause is HAVING tblesaleno.saleno = forms!frmsale!salen
How can I not include a specific saleno and still count # records for a certail sale? Does this make sense? If more info req'd please let me know
I have a problem that I havn't been able to sort through tried various but haven't come up with solution.
I have a 'simple' inventory db. Tracking parts coming in and useage. Requirements are to not issue parts for a Sale unless all parts on sale are available (in stock). I have this requirement working via a cmd button on the 'sale' basically behind the cmd button is code whic
For that sal
1) writes to a temp table parts that could be issued because stock is avialable.
2) count the above record
3) count the number of records on tblsaledetail for that sal
4) if #records in temp table = #records on sale then all parts are in stock and I can issue - I change a flag to true and write the itemdetails table to track store parts used
The above is working fine. But it is slow as currently the user has to go to each individual 'sale' and press the button in order to see if the 'Sale' is good to go
What I have done also is if the statement 4 above is false all parts aren't available I've updated a HOLD table with the date ON hold
Now my problem. What I'd like to do is have a button - not related to a specific sale record - that will go and do something like the above mentioned qry's to tell me what Sales I can take off of hold. i.e. when new stock is recieved, press i.e. a Stock Check button. it all the parts on the sale are there enter current date into the dateoff hold field. This will allow me to give them a report to tell them what sales they can go an issue
basically my code is grouped and the where clause is HAVING tblesaleno.saleno = forms!frmsale!salen
How can I not include a specific saleno and still count # records for a certail sale? Does this make sense? If more info req'd please let me know