Need help with "grouping" on a form

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?
 
S

Sandra Daigle

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Form with sub-form and custom Ribbon 0
Form/Subform with Parameter 2
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Main Form with Subforms 5
Grouping Names in Mail Merge 0
DMax on existing record to increment serialized # fails 1
Macro to Combine Data from Multiple Sheets with Cell References 4

Top