Subform Help - Recalling Data   

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

date: Tue, 08 Jul 2008 20:35:52 GMT   author:   theRepublic u44732@uwe

Re: Subform Help - Recalling Data   

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


"theRepublic" <u44732@uwe> wrote in message news:86db46a66ca7f@uwe...
> 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
>

date: Fri, 11 Jul 2008 17:38:53 +1000   author:   Jeanette Cunningham