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.



Trades (Subcontractors)





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