DLookup

[Ingrid]

Merry Christmas,

I would like the use the following tables.

Table 1
Product Unit Price
1 $10.00
2 $5.00

Table 2
Component ID Product Component
1 1 A
2 1 B
3 2 T
4 2 U
5 2 V

These tables will save the product and component information like a
order details form. Just like when using a DLookup function, you type
in a product in the table 1 and the unit price is updated
automatically from the products table. I would like to update a cross
query or something to that effect. I need have the form update a sub
form with multiple components for every product.

I would appreciate any advise.

Thanks

 

[Steve Schapel]

Ingrid,

Do you mean this?... You have a main form based on Table 1 (the
Products table), and then you have another form based on Table 2 (the
Components table), (in this case the Product control on the COmponents
form would not need to be visible), and then you put the Components form
on the Products form as a subform. So when you view the record for
Pruduct #1, for example, on the Products form, the subform will show you
the Components for that product. So, did you try it? This should work
well. Was there some problem getting it to work for you?