Hi,

I have to use filemaker for a project, but have been programming db's for many years. I'm trying to adjust - it is not easy

Anyway, my problem is, how do you set more than on field from a lookup/value list.

For example, say I have the following two tables:

work_selections:

record_id

selection_name

cw_split

ex_split

selection:

selection_name

cw_split

ex_split

So the user adds record to the work_selection table by picking from the selection table. I have the portal and so on working, and I can add new records to the work_selection table, with the selection_name being filled in correctly. What I need to happen is for the two "split" fields to be copied from the selection table corresponding to the selection_name. These need to be physically stored in the work_selection table as the default values provided by the selection table may be adjusted.

I would greatly appreciate any feedback.

Thanks,

Ian

Define these split fields as lookups from a relationship based on the selection_name field.