AnsweredAssumed Answered

Join vs New TO

Question asked by user28671 on Nov 29, 2018
Latest reply on Nov 29, 2018 by beverly

Hello all,

 

I have a project that has the following tables.

 

Client

Trades (Subcontractors)

Projects

Activities

 

 

I need to have a master list of Trades for each client.  So a client may have 100 Trades.  I need to be able to select from that master list of Trades to add them to a project.  So a project may only have 20 of the 100 Trades.

 

Eventually, a Trade will be assigned to each activity to be completed.

 

I linked everything properly in the Relationship graph: Client - Projects, Client - Trades, Projects - Activities.

I thought I should create a join table between Trades and Projects, but filemaker said I needed to create a new TO to make this happen.  So, I created a new TO and this doesn't seem to the be correct procedure either.

 

Could someone help me along here?  I seem to be stuck.

 

- Ashley

Outcomes