Incorporating different fields of data into a related table
I have my own company in Apple hardware support and I use a database called "Service" to fill in all the details of a broken Mac.
I use two other databases containing my clients called "Customers" and one containing my inventory called "Products".
Now when I fill in all the details of a broken Mac, I link it to an existing customer (from "Customers") by filling in the name of the client in a related field. Then I would like the rest of the client info to appear automatically in the other fields (incl address, phone number, etc...), how do I do that?
Then there's the other related question.
When the broken Mac is fixed I would like to input the parts and products I used in "Service" by typing the ProductName (related from "Products") but I would also like it to show the related product number and price in different fields automatically.
How do I do this the easy way?
Thx for your support!