Subform Help - Recalling Data

[theRepublic]

Hey Experts. Please help! I’ll try to keep this is as short as possible.

My issue I need help with is with my Orders Subform in the Main Customer
Information Form.

I would like it so that when a customer orders a specific Size/Dimension for
the advertisement, I can have a dropdown list with the 5 different types of
Size/Dimensions. Then, after specifying the # of runs, I would like it so
that the Rate and ProductID are automatically recalled from my Productstbl.

The Productstbl lists all the possible combinations of Size/Dimensions, Terms,
and Rate. Although there are only 5 different Size/Dimensions a customer can
order, there are 61 different combinations of terms and rates. So I've got
everytihng covered. I’ve attached a print screen of the Productstbl. In terms
of the subform, my questions are:

1) How do I get the Size/Dimension to have a dropdown list to specify the 5
different size/dimensions.
2) How do I get the subform to automatically recall the Rate once I have
specified the Size/Dimension and Term.

I know the answer lies within the query that takes fields from the
Productstbl and the OrderDetailstbl. How do I solve my questions?

Thanks

 

[Jeanette Cunningham]

Hi,
first you create a new table with one field.
Give the field a name like SizeDimens and make it a text data type.
Save the table with a name like tlkpSizeDimension

Switch to datasheet view and enter the 5 different types of Size/Dimensions.
Use this table to create a query to use for the dropdown list for your form.

If you can give us some more info about the # of runs and how the Rate and
ProductID are related to the # of runs and Size/Dimension, we can give some
more advice.


Jeanette Cunningham -- Melbourne Victoria Australia