SQL Join

[KPR]

I have two tables (tbl1 and tbl2), each of which has a [CustomerID] and a
[Memo]field. How do I join these two tables by [CustomerID] and run a query
that would allow me to view both Memo fields and copy the text from one into
another? Each join I try puts the datasheet into Read-Only mode with no edits
allowed.

Thanks,
Ken

 

[Golfinray]

You go ahead and join them and run the query. Then turn it into a make-table
query and run it and create a table. Now your table is editable and when you
make a query from that table, it will be editable also.

 

[KPR]

Thanks for the reply,
I need to be able to update this data live in the two tables.

You go ahead and join them and run the query. Then turn it into a make-table
query and run it and create a table. Now your table is editable and when you
make a query from that table, it will be editable also.

I have two tables (tbl1 and tbl2), each of which has a [CustomerID] and a
[Memo]field. How do I join these two tables by [CustomerID] and run a query
that would allow me to view both Memo fields and copy the text from one into
another? Each join I try puts the datasheet into Read-Only mode with no edits
allowed.

Thanks,
Ken

 

[John W. Vinson]

I have two tables (tbl1 and tbl2), each of which has a [CustomerID] and a
[Memo]field. How do I join these two tables by [CustomerID] and run a query
that would allow me to view both Memo fields and copy the text from one into
another? Each join I try puts the datasheet into Read-Only mode with no edits
allowed.

Thanks,
Ken

Is the CustomerID unique within each table? If so, create a unique INdex on
it; the join should then be updateable.

If there are multiple records with the same CustomerID, how can you tell which
memo field to update from and update to?