G
Guest
I have a form with two subforms. It took me all day to get it right.
I don't want to do it over. On one subform there is a small related table
with one field that I left off. I tried adding the field and of course it
doesn't show up in the fields list. There must be an easier way to do this
in a query so you don't have to keep redoing the form.
Is there a way to add one more table to a subform so I can edit the form?
I have one main table with two related tables and the related tables have
related tables. I tried one big query with all the fields of all the tables
on it and that didn't seem to work. So I just break up the related tables
into groups and make the queries that way then base the form and subforms on
the grouped related tables?
thanks,
I don't want to do it over. On one subform there is a small related table
with one field that I left off. I tried adding the field and of course it
doesn't show up in the fields list. There must be an easier way to do this
in a query so you don't have to keep redoing the form.
Is there a way to add one more table to a subform so I can edit the form?
I have one main table with two related tables and the related tables have
related tables. I tried one big query with all the fields of all the tables
on it and that didn't seem to work. So I just break up the related tables
into groups and make the queries that way then base the form and subforms on
the grouped related tables?
thanks,