how to view 4 tables via 1 form

[odun]

Hello all,

I have an access db with 4 tables that have a common field called customer number.

I would like to do the following:

a) view some of the different fields in these 4 tables in my form,
b) update 1 of the tables via the form


Thanks for your help

 

[allan57]

use a query to obtain the desired data from the four tables and use that as your form recordsource

 

[odun]

That's exactly what I did, but I could not update the table I wanted to update. When I clicked on the field I wanted to update in the form, I got a beeping sound like the field could not be edited.

 

[allan57]

It would appear that the query you have created is not updatable, have you got the primary key set on customer number in your tables?.