This is where it would be good to have some in-depth knowledge on forms/subforms design. The more you keep the relationalship without the intermediate table, the more you can easily design the subform. The best advice I can give is to look at the tables whcih have only 2 id fields and see (given your requirements), if you could make it fit into one of the other tables as a foreign key. Otherwise, plan on a little more complex form design to acommodate the intermediate table.