Tables in the form designer

R

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

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]
 
A

Albert D. Kallal

A form by its nature tends to get it data form a single table, or a single
query.

While a query can be built to include the fields from a child table, in the
case of "many" records for the child table, then which particular child
record do you want to be included when you edit?

Hence, the normal solution is to use a sub-form. When you do this, then
ms-access will manage the "many" side for you automatically, and you WILL
see a field list of possible choices when you design, or modify that
sub-form.

So, for the most part, you sue sub-forms.

I talk about this here:

http://www.members.shaw.ca/AlbertKallal/Articles/fog0000000005.html

Also, often we need to display "grids" of data, and again I often use
sub-forms. Here is some more screen shots:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm
 
Top