Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 193
  • Last Modified:

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
0
Motaz
Asked:
Motaz
  • 3
  • 2
1 Solution
 
ZifNabCommented:
Hi Motaz,

Go to the People table : double click -> you come in fields editor.
Click right mouse.

Choose add fields (select all)
Choose new field
choose type lookup and fill in the needed stuff (lookupsource, lookupfield, keyfield; etc)

Regards, Zif.
0
 
MotazAuthor Commented:
Did that mean I must not define country table as a lookup table ?
0
 
ZifNabCommented:
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.
0
 
MotazAuthor Commented:
Okay thanks.
0
 
ZifNabCommented:
when new problems arive, just ask.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now