In the <Items> table:
Col 1: Item_Type Col 2: Expiration_Days
Ex: Col 1: Milk Col 2: 20
In a separate table <Sales> I want to select and item from <Items> Col 1 (Milk)<a combo box> and have the value from <Items> Col 2: used to calculate the Expiration date in the future and enter the result into the <Sales> table in an adjoining cell in the same row.
The result would look like this in the <Sales> table:
[Date] [Item] [ExpDate]
Today Milk Today + 20 days
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Hinsel
I have two tables. <Items> & <Sales>
In the <Items> table:
Col 1: Item_Type Col 2: Expiration_Days
Ex: Col 1: Milk Col 2: 20
In a separate table <Sales> I want to select and item from <Items> Col 1 (Milk)<a combo box> and have the value from <Items> Col 2: used to calculate the Expiration date in the future and enter the result into the <Sales> table in an adjoining cell in the same row.
The result would look like this in the <Sales> table:
[Date] [Item] [ExpDate]
Today Milk Today + 20 days
Thanks for any assistance.
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.