ms access - Form based on a one-to-many relationship - just show parent records with child actions -

i have 2 tables, 1 parent records, , 1 child records.

the child records displayed in subform attached bottom of form containing parent records.

i want main form's recordset consist of parent records child records exist. however, when try this, multiple parent records (i.e. if flick through records, have pass 4 parent records if there 4 associated child records, etc.).

i think need use group when try create query (so might able base form on it) tells me need group on fields in query, errors when so.

please help!

thanks

i don't know how populating main (parent) form, if find record source form, property sheet, click build button (...) invoke query builder, can add in (show) child table. assuming there exists relationship between 2 tables, create inner join. if there isn't relationship (a join) drag , drop primary key in parent table foreign key in child table.

you don't need include fields child table, have include fields need parent table in query grid. adding child table creates, mentioned, inner join, show records parent table if have records in child table.

close , save query builder.