Having not worked in Access for years and, having casual skills at the best, I’ve managed to build several business useful dBs over the years. Presently I am working on a project that has presented me with a problem that has me baffled. I have two forms: fJobHeader based on a query joining tables JobHeader (key JobNo an AutoNumber) and Customers (key an AutoNumber field – CustNo) (the later table is included simply to populate names associated with the Customer No). The second form fJobLines is based on a table JobLines (key is JobNo & LineNo) and is presented in continuous forms format.
My problem is that I want to start each job line set with line number 1 and add sequential lines thereafter. My intention is to open fJobLines from fJobHeader - if there are no lines associated the first JobLine should be line 1. If there are already JobLines associated a new record would have the JobNo automatically inserted and, the LineNo would be sequential from the last record.
I can make this all work if there are existing JobLine records but run into issues on making it work on new record sets. Additionally, my solution is not very elegant, using 4 unbound text boxes and programmatically assigning values in a sequence of events. While I can make it work, I don’t have faith that it is the best way to get where I am going and will prove unstable for practical use.
Any suggestions?...Anyone??
Thanks,
Paul