Combining 2 tables on One Form and Updating One

G

Guest

I have two tables; the first is generated by SQL Server and transmitted to
the Access application via DTS. It contains many records. The second table
has few records which are entered manually through the form. The user must
be able to see all records on the form as if it were one table. If the
tables are joined in a union query and the query is placed in the
RecordSource property of the form, the data is displayed as required, but the
form cannot be updated. Is there a way to allow the second table to be
updated on the same form and allow both tables to be joined and display on
the form as if it they were one table?
 
A

Arvin Meyer [MVP]

I've never tried this with dissimilar data structures, but I have with all
JET Union queries. I add an unbound subform to my form and manually write
the values to the specified row in the table, then requery the form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Two Tables Using One Form Contents 0
Separate Form 0
1 form, 2 tables 1
Form with Multiple Tables 1
Forms 7
Combining a data from a linked table and a regular table in one fo 2
have one form open many tables 12
Creating a Form To Update Multiple Tables 2

Top