Table Relationship Question
I'm sure this is a simple question but I just can't think of the answer.
I have a table called Breakouts which contains all of the overhead for a project (i.e. employee salaries, etc.). These are static costs which don't change, and I have set it up so they are all in one record on one layout with 6 different subtotal fields. I have a second table called Main that contains fluxtuating costs for several shots. Each shot cost is in its own record.
I would like to have the subtotals from the one record on the Breakouts table to appear on the Main table so I can calculate all the costs together on one layout. I'm having trouble figuring out how to relate these two tables together since there's no relator field (i.e. no prime key) on the breakouts table. Can you guys help advise me how to set this up?
Please let me know if you need additional details.
Thanks a lot!