hi lars-inge
thanks for your response. in the main table, i have standard name and
address details, eg. NAME, ADDRESS, POSTCODE, COUNTRY, TELEPHONE. the
COUNTRY field i want to be a dropdown combo. in this table there is a 2
digit code, eg. UK, DE, US, FR etc.
the other table is the lookup table for countries. in here i have the same
2-char country code as above, along with extra info on the country eg.
LONGNAME, SHORTNAME, POPULATION, CONTINENT etc. there is a fixed list of
countries that must be chosen from - ie. no free-text.
in the drop-down i can show either the 2-char code, or the LONGNAME for
example, whichever's easiest. but when the name/address window opens, it
must display the correct value for that particular record.
so, selection of the dropdown is not friving the name&address record that is
selected, it is just altering the particular field value for this record.
hope that helps your understanding of my problem.
many thanks,
barry
"Lars-Inge Tønnessen (VJ# MVP)" wrote:
Hi Barry,
More details, please.
What is stored in the "another table"? (Examples)
In the compobox lets say we have:
"UK"
"Norway"'
"Ireland"
What do the "actual source values" look like?
Regards,
Lars-Inge Tønnessen