Form with a Lookup Table

[SyntaxError]

I create an AutoForm from my ORDERS TABLE. Is there a way to make a
form that's similar to an invoice.

What I mean is my ORDER FORM will have the [Order ID], [Order Date]
[Quantity], [Product ID], and [Customer] from the ORDERS TABLE.

But I want a subform part with a lookup table (drop-down list) of
[Product ID] from the PRODUCT TABLE. And this subform will lookup the
[Price] from the PRODUCT TABLE.

Syntax! --- Trying to push the limits of Access....

 

[John W. Vinson]

I create an AutoForm from my ORDERS TABLE. Is there a way to make a
form that's similar to an invoice.

If you're going to use it to *print out* an Invoice to mail, then
don't use a Form - use a Report. Forms are for onscreen viewing;
Reports are for printing. You might want both of course.

What I mean is my ORDER FORM will have the [Order ID], [Order Date]
[Quantity], [Product ID], and [Customer] from the ORDERS TABLE.

But I want a subform part with a lookup table (drop-down list) of
[Product ID] from the PRODUCT TABLE. And this subform will lookup the
[Price] from the PRODUCT TABLE.

Syntax! --- Trying to push the limits of Access....

Not very hard yet... <g>

Take a look at the Northwind sample database that came with Access.
The Orders form does precisely what you're describing.


John W. Vinson [MVP]