Vicar
Registered User.
- Local time
- Today, 17:24
- Joined
- Aug 9, 2005
- Messages
- 13
I am making a service db, and one of the main functions in it, is customer's current equipment list with a parts sublist.
These are the fields in the servicing equipment table and it is a duplicate of equipment table (EQ ID,Name, Manufacturer,Model,Serial,DateLastServiced(gets updated from a dispatch date in the new service form),CustomerID,ServiceID) .
basicaly i select acustomer, got to service form(carries over customer data) shows service tickets for selected customer, addNew/Edit has a service equipment subform, where i want to be able to lookup and add the whole string from above. Originally i was going to have cascading lookups, but some customer s will have a lot of equipment and it would be too complicated to keep a correct record.
If you are still with me my Goal is: all the fields above in one lookup that will be displayed at the same time.
Any ideas/Need clarification - let me know.
Thanks
V.
These are the fields in the servicing equipment table and it is a duplicate of equipment table (EQ ID,Name, Manufacturer,Model,Serial,DateLastServiced(gets updated from a dispatch date in the new service form),CustomerID,ServiceID) .
basicaly i select acustomer, got to service form(carries over customer data) shows service tickets for selected customer, addNew/Edit has a service equipment subform, where i want to be able to lookup and add the whole string from above. Originally i was going to have cascading lookups, but some customer s will have a lot of equipment and it would be too complicated to keep a correct record.
If you are still with me my Goal is: all the fields above in one lookup that will be displayed at the same time.
Any ideas/Need clarification - let me know.
Thanks
V.