Query/table/form?

[sir_dan_mitchell]

how can you base a form on a query, and still when u enter new records in the form, the data gets stored in the required table?

 

[Fizzio]

The query produces a dynaset of the data from each table. As long as the query is updateable, as you update/enter info into the query results, the data will be stored in the underlying table(s)