Need help with "grouping" on a form

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I have a table where each record has a field called
MasterID and a field called SubID. There can be four
records with the same Master ID, so those records would
be:
Master 1 Sub 0
Master 1 Sub 1
Master 1 Sub 2
Master 1 Sub 3

I'd like to create a form that will show all, and only,
the records that have the same Master ID, then be able to
navigate to the next Master, etc. Suggestions?
 
Hi Ken,

Use a form to show the 'Master' Records and a subform to show the Sub
records. Link the form/subform using the SubId field.
 
Back
Top