October 16, 201213 yr 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
Create an account or sign in to comment