I have imported my existing customer list and would like to link it to a service call table. So I would like to select the customer and log a service call for that customer. If I do a one to many with customerbeing one and calls being many and enforce refr integrity it wants a record in customers. Also I have a rma table (return materials authorization) which might or might not be issued. So once again I have (maybe) many rma# for one customer and maybe one rma per call. How do I link these tables and do I enforce ref integrity?
Thank you for your time and help