Need some basic help with setting up database relationships
This is probably a very basic question (my skills with Filemaker are quite basic) so hopefully there is an easy answer. I am setting up Filemaker for our small business and am a little stuck with making the realtionships work the way I want them to. I hope this is the forum for people like me. My apologies if not.
To quickly summarise my needs, I have 3 tables;
Customer Vehicle Details
I have matched fields between Customer Details and Vehicle details (Customer ID)
I have matched fields between Vehicle Details and Job Details (Vehicle ID)
I want to also match the Customer ID field between Customer Details and Job Details but this creates a cycle which I understand is not allowed. Filemaker automatically creates a new table when I try to do this but I don't then know how to use it! How do I get customer details to relate to Job details?
Does this even make sense?
Any help greatly appreciated.