Hello,

Is there a 'best practice' when it comes to creating forms based on many
different tables? Generally I try to use as few subforms as possible, using
them when I can no longer create a single updateable query. (Often resorting
to code when I know I should use a subform).

Also, how many subforms do you typically use on complex forms? And how often
do you use subforms within subforms?

I'm going round in circles trying to work out the most efficient way of
doing a form at the moment that is based on one table, that is a parent of
another table, that then has numerous other lookup tables, link tables, child
tables and another parent table itself. It's the many to many link tables
that cause the headache, I'm thinking they should each have their own suborm
and then further subforms within them if required.

Any guidance on the best theoretical approaches much appreciated.