Relating fields from separate Tables after importing

[scchoi]

Hello FMFileMaker,

So here's my dilemma:

I imported the data into my database. The following database has a STAMP Table with a list of stamps with primary keys. Each stamp in addition is given a FOREIGN key. This FOREIGN key is labeld as a _kf_Type (as in, the type that the stamp is categorized by ie: Type 1A, blue.. Type 2A red, etc...)

In my TYPE Table, I manually entered the Type according to the Primiary Key. IE:

_kp_TypeID is 1000

Type name is Type A1, Brown

_kf_StampID is 1

Now what I want to do is some how show on he detail layout of each stamp the TYPE that corresponds to the stamp. All iI'm getting is the _kf_StampID number which is what I originally imported into the database from excel.

For example let's say one of the stamp has the _kp_Type of 1, I want it to display Type A1, Brown instead of "1".

Thanks in advance for your input