I have a db with about 5 tbl's. One of these contains information which all other tbl's use. All tbl's are joined to the main tbl by one to many (one is the main tbl). data goes in to the tbls via a form using three sub forms. My problem occurs when I enter data in one tbl in particular and then the query which is used to report creates multiple entries of the same data. I have noted that one field which is contained in the Main tbl and which is used by all tbls thereafter is not showing up in the query. Eve though I have ID's linking the various tbl's this vital field seems to go missing in the query?:confused: Any takers.

query which is used to report creates multiple entries of the same data - you have a table in the query that is not related. From your description of the table schema, it sounds like none of your queries should join more than two tables. If you have a third table, it may be related to the 1-side table but it is not related to the other many-side table and that is what is causing the duplication. If you want to show data from more than one of the many-side tables, you'll need to do it by adding subforms or subreports for each one. One query won't work.

If a field doesn't show in your query, make sure that it is selected and is flagged to show (the show checkbox has a check in it).

Thank you PH.
I have the subforms going already so it looks like I need to use an extra query or two to view the data, using a sub report. As the problem is only one tbl I might be lucky?:rolleyes: