Valuelist updating two fields

[nutthick]

I have one table ('Bank') that holds two fields; name (text field) with 4 records of 'bank1' 'bank2' 'bank3' and 'bank4'; and a second field; drive (number field) that holds a unique drive number.

In my second table I have the user choosing a bank via a valuelist from Bank::name. What I would like is when the user selects a bank, the associated drive number is also copied into the local table's duplicate drive field. I can't use a standard relationship, as the drive fields in 'Bank' will change over time, but I don't want my local table to reflect the changes, but to keep the value it was assigned.

Essentially I want the valuelist to update two fields in my local table and then to leave them unchanged, regardless of what happens in 'Bank'.

Can anyone help? Hope this is clear

Thanks

[Vaughan]

This sounds like a job for... Lookups! Or in FMP 7, an auto-enter calculation.

[nutthick]

Vaughan - Do you mean just running a script? Ideally I just want the user to perform a single action with a single valuelist. If I could run a script after they used the value list everything would be peachy, but I can't see how.

[Mindi]

This is my problem exactly... does anyone have an answer to this?