I'm Newbie of Filemaker Pro 11, I became from MS Access.
I'm trying to create a combo box connected to a table. (product form
with categories field)
I want to use the ID in the categories table joined with the
correspective IDCategories in the Product table.
In a Form I create a comboList that use the table of the categories,
but I can view always only the ID of the categories and not the
description.
Can i have (like in Access) one filed in a form joined with the ID but
displaying the description of the field?

Thanks for any suggestion
Best regards
Nick

On a Mac it works fine with a Pop-up...but not on Windows the last time I tried it.

2 options:
1. Also include the description as a second field in the value list, and then place the related field right next to it, so it displays the description along side the ID in the value list.

2. Show only the second field in the value list. Place the ID field underthe related description field, so it hides it. Make the description fieldso you can enter it in browse mode (uncheck the box in the Inspector), that way when you click on the description, it actually enters the ID field...which shows you the value list with the descriptions listed for you.

On 19/05/11 6:27 PM, Nick wrote:



you need a relationship, i.e. a Categories TOC (table occurrance)
attached to Product TOC via category_id

TOC:

Product::category_id to Categories::category_id


if the product was entered into a invoice line item table for example,
then a 'hopped rel' would be required to display the line items with
product category in a portal on an invoice form :

Invoice::invoice_id to InvoiceLines::invoice_id and
InvoiceLines::category_id::Category::category_id



' combolist' is called 'Value List' in FM


When you attach the VL to the Product::category_id , if you add it as a
PUM ( not as a DDL) to the Product::category_id field , and define the
VL to show the category_id (first) and category_name (second) and show
only second field, the PUM will list only the category names, but
actually enter the category_id into the Product::category_id field. Add
a second Product::category_id field , without the attached VL, as a
test to show this working.