Data in ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey,
I have a design issue that is making me nuts. I have a chemical inspection
item that can be a single value like '7.48 MAX' or 'HB MIN' or in a range
like 23.5 +- 1.5.
I would like to put these is a lookup table so they do not have to be
re-entered for a specific inspection item.
TIA,
REL
 
Create you table and enter the data. Create a query that sorts them,
probably ascending. In your data entry form, I hope you are entering data
via a form, place a combo box based on this query and set its control source
as the field in you main table where you want it. If you don't change the
values in the new table, you can assign an Autonumber primary key and store
that value in your main table (you can then recall the actual value in any
query, form, or report.)
 
Back
Top