Linking Tables to Forms

[shamas21]

Hi All

I have two tables and I have numerous textboxes on my form. Im trying to link the text boxes to each column within my tables. It works fine for one table as i choose the table from the Data - Record Source, but it wont let me choose two tables to link to the Form. I have even tried making relationships betweent the tables but that doesnt work either. Can some one help?

Thanks

 

[pbaldy]

To bind the form to 2 tables, you would need to bind the form to a query that joined them. Whether that query is updateable depends on a number of factors:

http://allenbrowne.com/ser-61.html

http://support.microsoft.com/default.aspx?scid=kb;en-us;328828

 

[GaryPanic]

what is the relationship between these two tables ..
you will need to know PK and FK
PK (Primary Key)
FK (Foerign Key)

table 1 with have a PK (which will need to be the FK in table 2)
table 2 will also need PK and aslo a field for FK (being the one above)

these need to be numeric (for ease)

then as PB suggests base formon qry..