Subform displaying all 24158 records in Products Table

[mthornblad]

I created a form/subform using the form wizard. This was based on 2
queries. 1 for the Invoice Summary and 1 for the Invoice Detail.
When you select the (open the form to view or enter information
option) the subform has 24158 records. All have the same Product
Number but the descriptions represent every record in the Products
table. All 24158 of them.

The "link child fields" and "link master fields" properties are blank
in the respective tables.

I am obviously doing something drastically wrong.

Please help.

Thanks
Mark

 

[ruralguy via AccessMonster.com]

You need to set the Invoice Number as the LinkChild/MasterFields. Then only
records that have the Invoice Number of the MainForm will show in the SubForm.