Im very new to Access 97 and Im sure I should be able to do this but
cant work out how.
Im bulding a database for my stamp collection. I have two tables; one
with details of all the individual stamps, and one with details of
covers/envelopes the stamps are fixed to. Each indivdual stamp has a
specific reference number (not an auto-number). Rather than manually
enter the reference number into my 'covers/envelopes' table I want
Access to give me a drop down list of the possible ref numbers to
choose from.
So if there are five different stamps which have been issued with a
value of £1.20, and the cover Im cataloguing has a £1.20 stamp on it,
I can select the ref number from an automatically generated drop down
list that doesnt have all 250 stamps of all values on it - just the
two or three £1.20 ones.
Any suggestions would be welcome.
Thanks
Phil
cant work out how.
Im bulding a database for my stamp collection. I have two tables; one
with details of all the individual stamps, and one with details of
covers/envelopes the stamps are fixed to. Each indivdual stamp has a
specific reference number (not an auto-number). Rather than manually
enter the reference number into my 'covers/envelopes' table I want
Access to give me a drop down list of the possible ref numbers to
choose from.
So if there are five different stamps which have been issued with a
value of £1.20, and the cover Im cataloguing has a £1.20 stamp on it,
I can select the ref number from an automatically generated drop down
list that doesnt have all 250 stamps of all values on it - just the
two or three £1.20 ones.
Any suggestions would be welcome.
Thanks
Phil
Comment