frankst

Connecting Tables best practice?

Discussion created by frankst on Jan 28, 2015
Latest reply on Feb 2, 2015 by erolst

Hi,

 

I have looked at the Lynda training for Filemaker Pro 13 which really helped me allot (new to Filemaker Pro)

But I like to link multiple tables in the Relationships, what would be the best practice here? In the Lynda training it only goes over 3 tables with a 4th one to connect the 3.

 

I have the following tables:

  • Customers
  • Employees
  • Work Order
  • Task

So I like to have the relationship where you create a new Work Order for a Customer, in that Work Order should be able to create a Task where you can assign a Employee to it.

 

I guess my next following question would be they interchange as in you can view all the Tasks a Employee is assigned to, view all the Work Order of a Customer and back and forth.

 

Thank you

Outcomes