Repost: When I add a record to the table it doesn't show up in fo

[Tia]

Tom,

There is a relationship between the two tables and I specified that it
should enforce referential integrity. However, I'm not sure how to check the
foreign key's required property.

The weird part is that there are some other forms that use these same tables
and it updates them if a record is added to the table, could there be
something on the form that needs to be changed??

Thanks for your help!

Hi Tia,

This sounds like it might be a default inner join issue. An inner join will
only include records from both tables where the joined fields (Customer ID)
are matched. Have you created a relationship between these two tables, using
Tools > Relationships to define a relation? If so, have you specified
Enforce Referential Integrity? Finally, have you set the foreign key's
Required property to Yes?


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

Was this post helpful to you?

Why should I rate a post?



Expand AllCollapse All