filtering a query

[chris11590]

i would like to create a form based off a query; showing a few records to display at a time, perferribly by one specific branch. my query allows duplicates values.

i have tblebranch (one side relationship)and tblegroupsector (many side relationship). at the end i would like to see one specific branch to many of the group sectors. presently my query results show duplicate branch to many groupsectors.


i believe this is a filter can anyone help?

 

[georgedwilkinson]

You would set this up as a main form/subform. Just let the form wizard walk you through it. It will ask you which tables you want on the forms and let you say how you want them presented. Then when it's done, you can drag the fields around where you want them to make it look nice.