L
Lux770
Hello all,
I am quite unexperience with Access so I hope you can help me.
I am building a database which mainly uses 3 tables:
tProducts: ProductID, ModelID
tMarketOffering: ProductID, MarketID
tModels: ModelID, ModelPrice
Each product is based on a model, with optional features that can be added
to it(handled by an additional table not mentionned here for simplicity).
Each product is offered in one or several markets. Each base model has a
unique price.
tProducts is linked (1 to many) to tMarketOffering thru Product ID, and to
tModels (many to 1) thru ModelID. I built a query selecting ProductID and
ModelID from tProducts, MarketID form tMarketOffering and ModelPrice from
tModels.
The query seems to work fine: It shows for each ProductID, the model it is
based on, markets where it is offered and the base model price. I can then
amend or add records as needed. However, there is a strange thing happening
with MarketID: unlike the other fields, when adding a record I cannot select
any market (I use a ComboBox). I have to click on another record, then come
back and only then can I make a market selection.
Would anyone know what is going on here?
Many thanks in advance
I am quite unexperience with Access so I hope you can help me.
I am building a database which mainly uses 3 tables:
tProducts: ProductID, ModelID
tMarketOffering: ProductID, MarketID
tModels: ModelID, ModelPrice
Each product is based on a model, with optional features that can be added
to it(handled by an additional table not mentionned here for simplicity).
Each product is offered in one or several markets. Each base model has a
unique price.
tProducts is linked (1 to many) to tMarketOffering thru Product ID, and to
tModels (many to 1) thru ModelID. I built a query selecting ProductID and
ModelID from tProducts, MarketID form tMarketOffering and ModelPrice from
tModels.
The query seems to work fine: It shows for each ProductID, the model it is
based on, markets where it is offered and the base model price. I can then
amend or add records as needed. However, there is a strange thing happening
with MarketID: unlike the other fields, when adding a record I cannot select
any market (I use a ComboBox). I have to click on another record, then come
back and only then can I make a market selection.
Would anyone know what is going on here?
Many thanks in advance