nutthick Posted February 7, 2005 Share Posted February 7, 2005 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 Link to comment Share on other sites More sharing options...
Vaughan Posted February 7, 2005 Share Posted February 7, 2005 This sounds like a job for... Lookups! Or in FMP 7, an auto-enter calculation. Link to comment Share on other sites More sharing options...
nutthick Posted February 8, 2005 Author Share Posted February 8, 2005 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. Link to comment Share on other sites More sharing options...
Mindi Posted February 17, 2005 Share Posted February 17, 2005 This is my problem exactly... does anyone have an answer to this? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6617 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 accountSign in
Already have an account? Sign in here.
Sign In Now