Query/Form not showing new record, Tables do though?

[hockey8837]

Hello,

I'm working on a DB setup by a different department and trying to make it work correctly for them, as they've hit a wall.

To keep things simple for now, this DB tracks in 3 tables A, B, and C. Table A has columns to store the ID# of B and C in it, as well as other data.

There's a 'master' query which pulls the data from all three of these, and a form to view all records based off this query, as well as a detail form for individual entry.

They've currently uploaded from excel about 350 records, which all show up in the query and form. However, when the user goes to enter a new record via the details form, this new record does not appear in either the query or form; but, its information still is entered into the 3 corresponding tables.

I've already spent an entire day trying to rearrange this thing (their method of data storage is not ideal)...but now I'm just stuck. Any suggestions!?

I'm using Windows XP and Access 2007.

 

[MSAccessRookie]

You stated:

"There's a 'master' query which pulls the data from all three of these, and a form to view all records based off this query".
​

This is usually a good place to start looking for answers. If the Form is not displaying data that you know is in the Table, then it must be because the Query is not finding it, since hte Form can only display records that the Query finds.

Run the Query by itself and see if the missing records are displayed. If they are not displayed, then you will need to evaluate the Query to determine why they are not. You can always come back to the Forum if you have any further questions.

 

[wilpeter]

Hockey8837: Do you mean that the New Record is entered after the query has been run? Presumably the query would need to be run After the new record is entered. Does the new record populate A B or C when input? Are the joins between the three tables appropriate?

 

[hockey8837]

Hockey8837: Do you mean that the New Record is entered after the query has been run? Presumably the query would need to be run After the new record is entered. Does the new record populate A B or C when input? Are the joins between the three tables appropriate?

Hi,
Right now, the DB uses a query to populate a datasheet list of all the records.

When the user enters a new record in a separate form, the information does go into the appropriate columns in tables A, B, and C. However, they do not show up in the query, and table A is not storing the associated ID #s for tables B and C.

I'm actually not sure if the joins between these tables are appropriate. I've tried a couple of different ways to connect them, but I can't get anything to work.

I've attached the DB for clarity.

Thanks!