How to link additional data source to a form

[adrian.stock22]

Hi All,

I have a db with three linked (related) tables. I have a form that has, at present, only one of these tables as a data source. Now I want to bring a couple of fields from another table into that form.

I know how to link a table to two data sources when first creating a table. But how do I do it when the table already exists?

I tried Table Design View | View Properties | Data source,
but that allows only one data source. If I link to another, the first disappears.

Thanks.

Adrian

 

[gavinjb]

the Form you want these data source on do you want to be able to update the data on 1 or all of the tables.