Add a second table in Form Design

[Rodney James]

I am designing a form in Access and I would like to use the drag and drop to
like you would for fields on to the lay out. I have two tables Main Table
and Lighting Table. When I choose View Vield list it only shows me the Matin
Table Fields. How can I see the Lighting Table fields? Or how can I link the
fields to the table Thanks for your help

 

[Rodney James]

Here is something else
In the design view of the from I took an existing field. Then right clicked
on it choose properties
on the "All" tab where is says control source I got the dialog box that
allows you to see the second table and I thought I had linked it. However
when I do to from view and look at the input of the field it says "#Name?.
When I try type in it says Control can't be edited its bound to the
expression '[Lighting Table]![Date proposal Sent]

Pleas any help is appreciated

 

[Rodney James]

Can some one please help me

Here is something else
In the design view of the from I took an existing field. Then right
clicked on it choose properties
on the "All" tab where is says control source I got the dialog box that
allows you to see the second table and I thought I had linked it. However
when I do to from view and look at the input of the field it says "#Name?.
When I try type in it says Control can't be edited its bound to the
expression '[Lighting Table]![Date proposal Sent]

Pleas any help is appreciated

I am designing a form in Access and I would like to use the drag and drop
to like you would for fields on to the lay out. I have two tables Main
Table and Lighting Table. When I choose View Vield list it only shows me
the Matin Table Fields. How can I see the Lighting Table fields? Or how
can I link the fields to the table Thanks for your help