Hi there, I am new to file maker. I have a table called category
(category_id (int) and description (text))
In the Product table, there is a field, category_id which is related to
the category table.
I have a drop-down list, where you can select the category and the
category name comes up fine.
However, when you finish selecting the category, the cateogry_id is
displayed, not the display text.

What am I doing wrong, I am sure there is an easy way for the display
member to be displayed and not the foreign key value?

Thanks

David.

Fortunately, when done, you get in the CategoryID, the CategoryID alone and
nothing else. Now, you can display near to it a field that shows the related
category name corresponding to the CategoryID you have choosen.
Remi-Noel


"Super Wasabi" <superwasabidave (AT) gmail (DOT) com> a écrit dans le message de news:
1162128270.657032.281330 (AT) m73g20...oglegroups.com...

Or you can swap the ID and the discription in your value list definition

Ursus

"Super Wasabi" <superwasabidave (AT) gmail (DOT) com> schreef in bericht
news:1162128270.657032.281330 (AT) m73g2000cwd (DOT) googlegroups.com...

Hi Remi

Ok, so there is no setting which can display the description field
instead of the value field.

How would I display the description field near to it? Do I need to
create a field in the Product table called CategoryDescription, which
is a lookup on he category_id? Not sure how to do this bit.

Thanks
David.


Remi-Noel Menegaux wrote: