Entering new data in a Query

[Ladybug1972]

Hi.

I am making a data base, where I need to combine 2 tables in a query. I then need to make a form based on the query.

My problem is that I can't enter new data in the query, it will only show me the data that I enter directly into the tables. So I can't make a form for entering new data, based on the query.

The problem only exit when the query has fields from 2 or more tables.

I have been away from database in a number of years, but in the old days a forms was almost always build on a query. Has that changed?

[UnklDonald418]

Forms that use a query as its data source can usually be made updatable if the Primary Keys are in both the query and on the form. If you don't want to see them on the form the Primary Key's can have their visible property set to No, but they must be on the form for Base to tell the database engine which record to update.

[Villeroy]

Post the SQL statement from the querie's SQL view, please