How to link additional data source to a form

[adrian.stock22]

How to link additional data source to a form

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

 

[jeremie_ingram]

You should be able to go to the properties of the form and there you should see the data source as the table that you have selected. Click on the ellipsis to the right of the field containing the table name and you will invoke the query builder.....
Since all three tables are already linked, you could easily add in all three to the builder and the select the fields you want from each.

 

[adrian.stock22]

Hi jeremie,

I have done what you said. All that worked OK. The form has now "All three tables query" as its source. "All three tables query" is linked to the three tables, and it shows specifically "Notes" from Table 3 and "Education Authority" from Table 2. In the query design view, both these fields look exactly the same.

Problem: Working in the Form: Whereas the "Notes" field is fully operational, "Education Authority" in Form View is not operational. It contains the message: "#Name?"

The Query is correct, as far as I can see: All three tables are displayed on top, and "Education Authority" shows in the Query Design Grid and is ticked. Just as "Notes" is.

Do I have to change something in the query? What? Or what?

Thanks for your help.

Adrian

 

[adrian.stock22]

sorry, and thank you.

Somehow this has sorted itself out now. THE WAYS OF THE LORD ARE MYSTERIOUS.

Adrian

 

[jeremie_ingram]

I am truly sorry for a slow response. I was in training and failed to check my e-mail.

There is one note that I would like to mention, you should base forms and reports off of queries instead of directly off of tables. This will give you greater flexibility for all changes you make in the future.