Tables & Queries

J

jyotisb

Hi,

I am working on a ACCESS database which had 3 tables. There were couple
of queries generated using either 2 of the 3 tables or all 3 tables.
There is another query also, which is based on the first 2 queries. Now
If I create forms based on this query,
1. I am not able to add/edit the data.
2. The tables are generated by importing the dbf files everyday
midnight.

I am confused..Do I need to merge all the data in one table and create
queries or Is there a better way to handle this problem?

Thanks.

J
 
J

John Vinson

Hi,

I am working on a ACCESS database which had 3 tables. There were couple
of queries generated using either 2 of the 3 tables or all 3 tables.
There is another query also, which is based on the first 2 queries. Now
If I create forms based on this query,
1. I am not able to add/edit the data.
2. The tables are generated by importing the dbf files everyday
midnight.

I am confused..Do I need to merge all the data in one table and create
queries or Is there a better way to handle this problem?
Click to expand...

There is: use the Relationships window to define relationships between
the tables; and use a Form for the "one" side of the relationship and
a Subform for the "many". You might have two subforms on one form, or
you might have a subform nested within a subform, depending on the
structure of your data.

John W. Vinson[MVP]
 
Top