Updating table in datasheet view..2 table query!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

If I create a query based on 1 table, I can then update the underlying table
by altering the data in the "datasheet" view of the query.

I want to recreate the same effect if I have a query based on 2 tables - can
it be done? and if not, can anyone think of a way of creating a similar
effect?

My query joins 2 tables on 1 field and displays all the fields from both.
the reason I want to do this is I want to manually look at fields in 1 table
and make a decision as to whether or not to manually change the fields in the
other table.
the idea is to put the related columns side by side so that an easy manual
comparison and change can be done!

thanks very very much if anyone has any ideas!

cheers!
 
Hi,

If I create a query based on 1 table, I can then update the underlying table
by altering the data in the "datasheet" view of the query.

I want to recreate the same effect if I have a query based on 2 tables - can
it be done? and if not, can anyone think of a way of creating a similar
effect?

My query joins 2 tables on 1 field and displays all the fields from both.
the reason I want to do this is I want to manually look at fields in 1 table
and make a decision as to whether or not to manually change the fields in the
other table.
the idea is to put the related columns side by side so that an easy manual
comparison and change can be done!

thanks very very much if anyone has any ideas!

cheers!
Click to expand...

If you have established a relationship between the two tables, and
checked the Enforce Referential Integrity checkbox, then yes - such a
query should be updateable. BUT...!

Three concerns here:

- It sounds like you may be storing information redundantly in the two
tables. Do you have the same information stored in both tables? If
so... DON'T! It's neither necessary nor good design.
- If you have a one-to-one relationship between the tables, be aware
that such relationships are VERY rarely necessary. If you do - what
are the two tables? What's in them?
- You may want to consider using a Form rather than table or query
datasheets. A Form based on the main table, with a Subform (in
datasheet or continuous form view) based on the related table will be
a user-friendly and effective way to see data from the two tables in
conjunction, and allow it to be edited.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top