A record with Primary Key created in table but doesn't show up in form

Mythblstr

Registered User.
Local time
Yesterday, 21:57
Joined
Nov 14, 2007
Messages
32
Hi,
I am using Acess 2007 and I have a database with 3 tables and 1 form. When I created a new record in the master table the record isn't showing up in the other forms.

I have also created relationships for the primary key between all of the tables but when I add the primary key to the child tables the record from the master table still isn't being recognized in the child tables.

If I'm not explaining my problem correctly please question me:o

Any help will be appreciated..
Thank you
 
Actually what I'm asking is how to get a record that was created in the master table to show up in an associated form. Please note that the form was was created before the record was created!:confused:
 
I have relationships between the tables but how do you manage relationship between a table and a form?
 
Can anyone tell me this much....If I create a new record in a table, should it automatically show up in an associated form??
 
If the form is bound to the table then the form should show all the records in the table.

Brian
 
Why would u have three tables but one form? what are the tables for?
If you have a form that has a record source a particular table and there is not filtering on you should be able to see all records.

Now if u have one table that is connected to two other tables and u want to automatically create a record in those tables with the same primary key when you create a record in the first table that is a different thing.
 

Users who are viewing this thread

Back
Top Bottom