Record added in table is not displayed in form.

[Guest]

I have 2 tables, Customer and System INformation. They are linked by the
Customer ID field. If I add a new record, it displays the information
accurately. I then have a form that I call Systems that updates the System
INformation table. If you enter a new record from the form, it is displayed
in the System Information table and will display in the customer table
according to the corresponding customer number, however, if I add a new
record straight to the System Information table, it does not show up on the
form as being entered. Any suggestions????

On a side note, I've other forms that display information from these tables
and they correctly display the record whether it was added by the form or
straight in the table.

Thanks for any advice!!

 

[Guest]

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
__________________________________________

 

[Guest]

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!