Access Form not populating from tables

[Jim from Waconia]

Hello, I am developing a DB that has a Main form that is pulling information from two tables. The first table is info imported from Excel. The second table is additional information the Import table does not have. When I import, the table populates perfectly, but the form will not display any data until I enter data into the cells on the second table. The tables both have a Primary key of the standard Access (ID) default with a one to one relationship. There are no filters.



Any ideas

[RuralGuy]

Change to an OUTSIDE (probably LEFT) join.

[Jim from Waconia]

Change to an OUTSIDE (probably LEFT) join.

You mean a one to many relationship?

[Jim from Waconia]

You mean a one to many relationship?

I got it, you mean in the Query - I'll give it a try

[Jim from Waconia]

After setting the join, my records do all appear in the form, but; When you add info in the form that pushes into table 2, the record you entered it into, say record 10 appears in the table as the third record. So after saving and opening the form, the data you entered for record 10 is in record 2.

Any ideas?

[Jim from Waconia]

Sorry the record appears as the third record not the second

[RuralGuy]

Do you have the PrimaryKey of one table in the other table as a ForeignKey?

[Jim from Waconia]

How do I do a foreign key? I might have an idea, but what do you suggest?

[RuralGuy]

Assuming an AutoNumber field as the PrimaryKey in table one then table two would have a LongInteger field with that same value in it as a ForeignKey.