Form not showing records in table.

[mbenton]

I have two tables, tblParts(parent table) and tblTask(child table). My parent table's primary ID key (PartsID data type is auto number) is located in the child table (PartsID data type is number)and there is a one-to-may relationship showing in the relationship pane.

At least half of the fields in tblParts is populated through an uploaded Excel spreadsheet and the upload goes smoothly. Once uploaded I populate the other fields manually. I have no data in tblTask, only a complete table with several fields and a primary key, TaskID and the foreign key, PartsID.

I used both tables to create a single form but that new form is completely blank! It's as though I have no records in the tblParts. Once the form was created I thought I would be able to open and see all the records from tblParts and then fill in the blank fiends associated with tblTask. Can anyone help me understand what I'm doing incorrectly? Thanks.

[pbaldy]

You would need to edit the join line between the tables. More commonly, a form and subform are used to represent a one-to-many relationship.

[mbenton]

Thanks pbaldy, I edited the join lines and it works.

[pbaldy]

Happy to help.