R
rasinc
I have a weird situation. I have a series of retailers who all have multiple
stores. The price per sku is set for each retailer but during certain
periods of time, the individual stores will have a different sale price.
When a user enters the price per sku at the store level, I want the
retailer's regular list price to be copied from the price per retailer table
for each sku and put into the store sku price table as the list price.
Ideally, when a user selects a sku from a drop down, I would like the
retailer's list price to show in the dblList field. I assume I need to write
some code for the on change event.
Then I need to lookup the value in the tblretailprice.dblListPrice where the
skuid and retailerid match the current record. I know I am building the
English for an SQL statement but I am not sure how to use it in Access.
Any ideas are greatly appreciated. TIA
stores. The price per sku is set for each retailer but during certain
periods of time, the individual stores will have a different sale price.
When a user enters the price per sku at the store level, I want the
retailer's regular list price to be copied from the price per retailer table
for each sku and put into the store sku price table as the list price.
Ideally, when a user selects a sku from a drop down, I would like the
retailer's list price to show in the dblList field. I assume I need to write
some code for the on change event.
Then I need to lookup the value in the tblretailprice.dblListPrice where the
skuid and retailerid match the current record. I know I am building the
English for an SQL statement but I am not sure how to use it in Access.
Any ideas are greatly appreciated. TIA