Multiple tables within one form (Access 2003)

[venna1]

I am trying to merge three seperate tables from three different access 2003 databases.

i want 1 form to access all three tables at a click of a button.

Does any one have a suggestion on how i would approach this.

Any info would be useful.

 

[Crowley16]

either create a query which gets the data from all 3 tables, or use an unbound form and fill/edit the records through code...

be careful when using a query because you can easily make the query non-updateable...

--------------------
Procrastinate Now!

 

[PHV]

you can easily make the query non-updateable
Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886