Jump to content

Valuelist updating two fields


nutthick

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

Recommended Posts

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

Thanks

Link to comment
Share on other sites

  • 2 weeks later...

This topic is 6979 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
×
×
  • Create New...

Important Information

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