AnsweredAssumed Answered

Need some basic help with setting up database relationships

Question asked by jenifben on Feb 10, 2009
Latest reply on Feb 13, 2009 by jenifben

Title

Need some basic help with setting up database relationships

Post

Hi,

 

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 Details

Customer Vehicle Details

Job 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.

 

Thanks

 

 

Outcomes