3 Replies Latest reply on Apr 11, 2012 3:27 AM by GuyStevens

    Incorporating different fields of data into a related table

    MichaelBrosens

      Title

      Incorporating different fields of data into a related table

      Post

      Hi everyone,

      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!

      Michael