Items that have 3 prices (1 Viewer)

henryihunter1954

Registered User.
Local time
Today, 10:04
Joined
Mar 2, 2016
Messages
89
I have an Item Table that needs to be changed and I need your assistance please.

In my Item Table:
Item ID
Item Number
Item Description
Item Cost

The problem arises with the Item Cost.
As an example, I need to give the Data Entry person the ability to select 1 of 3 prices.
Low - $60
Mid - $70
High - $90

There are more than 60 different Items in the table.
None of the Item Cost are actually the same.

I'd like the Data Entry person to put in one of the prices (Low,Mid,High) from a combo box.

Thanking you all in advance for any assistance.
(I've not visited this site in a long time and thanking you all for your previous help).
 

plog

Banishment Pending
Local time
Today, 12:04
Joined
May 11, 2011
Messages
11,638
You need a new table--ItemCosts it will have these fields:

ItemCosts
ic_ID, autonumber, primary key
ID_Item, number, foreign key to Item.ItemID
ic_Level, text, will hold the values of 'Low', 'Mid', 'High'
ic_Cost, number, will hold actual cost of item at that level

ItemCost then comes out of Item table. The drop down would simply have the 3 levels.
 

henryihunter1954

Registered User.
Local time
Today, 10:04
Joined
Mar 2, 2016
Messages
89
Thank you so much.
I was almost on the right track according to your suggestions.

I will follow your suggestions and thank you all for the great help.
This group is hard to beat when it comes to giving assistance.

Thanks again Plog
 

Users who are viewing this thread

Top Bottom