theRepublic
Registered User.
- Local time
- Today, 11:38
- Joined
- Jun 30, 2008
- Messages
- 11
Hey Experts. Please help! I’ll try to keep this is as short as possible.
I have a small newspaper company. The newspaper makes money by advertisements from local business owners. Advertisers request specific sizes for their advertisement, and pay according to its size. Typically customers advertise for runs of 2, 3, or perhaps 10 times in the newspaper and receive discounts according to how many Ad Runs and Size/Dimension the customer wishes to purchase. I’ve attached the relationships on this thread.
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. 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 Orderstbl. I’ve attached this query as well. How do I solve my questions?
Thanks
I have a small newspaper company. The newspaper makes money by advertisements from local business owners. Advertisers request specific sizes for their advertisement, and pay according to its size. Typically customers advertise for runs of 2, 3, or perhaps 10 times in the newspaper and receive discounts according to how many Ad Runs and Size/Dimension the customer wishes to purchase. I’ve attached the relationships on this thread.
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. 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 Orderstbl. I’ve attached this query as well. How do I solve my questions?
Thanks
