Motaz
asked on
Lookup table
I have two tables one for people name and the other for countries.
People table have some fields like Name and Country_Number. Country table have two fields : Country_Number and Country_Name. I define Country table as a lookup table for People table. When I enter data into People table I want to make a combo box in my for countries in my program instead of country number, how can I do that.
I use Delphi 3 Client/Server
Thanks in advance
Motaz
People table have some fields like Name and Country_Number. Country table have two fields : Country_Number and Country_Name. I define Country table as a lookup table for People table. When I enter data into People table I want to make a combo box in my for countries in my program instead of country number, how can I do that.
I use Delphi 3 Client/Server
Thanks in advance
Motaz
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
no,
you use two tables, one people, one country.
then you use two datasources pointing to one of each table.
then you use the country datasource as lookupsource in your newly created lookupfield.
Zif.
you use two tables, one people, one country.
then you use two datasources pointing to one of each table.
then you use the country datasource as lookupsource in your newly created lookupfield.
Zif.
ASKER
Okay thanks.
when new problems arive, just ask.
ASKER