Hi guys, here's the background:
We run a repair business and have been using paper based/spreadsheet methods to log each items progress. There are several distinct stages to the process and Access will help us input data and generate reports more easily.
- Item booked in (Customer's details, Item details, Fault Description details and date) Unique Repair Ref generated
- Item destination decided (Repair ref tied to a destination code - in house, engineer, manufacturer etc)
- Quoting (Customers details displayed from previous stages and part numbers, cost and labour added)
- Item returns (completetion date, collection status and collection date)
Have stored each stage in a seperate table so as not to duplicate data, however when designing the forms for the staff to input the data, i'm struggling to get the data from the first table to display in the form as no entry exists in the Quote table.
The 'New Quote' button runs a query to display item details based on the entry in the Book In table. I think I need it to pull up the data from the first table and create a new entry in the Quotes table using the Repair Ref as the primary key. Any ideas?
Thanks in advance
David