I have a project that has the following tables.
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.