Jump to content

Setting more than one field from a value list


iandmcneill
 Share

This topic is 6536 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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 smile.gif

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

Link to comment
Share on other sites

This topic is 6536 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.