This is probably one of the easiest relationship setups, but it is driving me mad!
Customer with address, phone fields etc.
Customers have lift(s) (elevators) of 3 types which have different fields in them.
Need to have servicing and breakdown records related to customers lifts.
Please could someone help me with a layout so as to know which fields to link together. Having 3 types of lift at the customers address is throwing me.