ulteriormotif
Technical User
This may belong in the tables forum, or forms for that matter.
I have a table where data is entered for exporter indicative prices (horticultural industry - exporters release prices at the start of each season for various markets, fruits and growing methods).
Fields are:
Season
ExporterID
MarketID
VarietyID
GrowmethodID (organic, conventional)
Priceperkg
No one field is unique - it is the combination of Season, ExporterID, MarketID, VarietyID and GrowmethodID that makes the record unique.
Because the indicative prices are released sporadically by the exporters, and updated on occasion, this isn't a 'once a year' data entry job - it's constantly being updated and added to, and it is not clear to the user whether they have an initial price or an update in their hands.
I can use a duplicate query to produce a report and catch when duplicate records (ie, all fields except for price) have been entered, but ideally I would like to prevent them being entered in the first place.
Any suggestions?
I have a table where data is entered for exporter indicative prices (horticultural industry - exporters release prices at the start of each season for various markets, fruits and growing methods).
Fields are:
Season
ExporterID
MarketID
VarietyID
GrowmethodID (organic, conventional)
Priceperkg
No one field is unique - it is the combination of Season, ExporterID, MarketID, VarietyID and GrowmethodID that makes the record unique.
Because the indicative prices are released sporadically by the exporters, and updated on occasion, this isn't a 'once a year' data entry job - it's constantly being updated and added to, and it is not clear to the user whether they have an initial price or an update in their hands.
I can use a duplicate query to produce a report and catch when duplicate records (ie, all fields except for price) have been entered, but ideally I would like to prevent them being entered in the first place.
Any suggestions?