Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Lookup - Don't change source?


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

Recommended Posts

  • Newbies

I have a lookup field which does the lookup just fine. However, if I modify the looked-up value in the destination file, it also changes the value in the source file. Can I prevent this? The lookup is for a price. I want the price to be looked up; if I subsequently change the price field in either the source or destination file, I do not want it to modify the other. Thanks.

Link to comment
Share on other sites

It sounds like you're using a related field rather than a lookup. When you look at the field in layout mode on the layout, does it begin with "::"?

If so, the this is a related field, and changing it will change its value in the related database.

Create a field in your local database called Price. Set it to be a number field. Click on the Options for the field and choose Looked-up value. Select your relationship from the menu in the top right and you will see a list of fields in the related database. Select the price field and click OK and then OK again.

You'll probably have to perform a re-lookup for your existing data. Do this by going to a layout that has the local field the relationship is based on (or create one if it isn't on any layout), click into the field, and choose Relookup from the Records menu. This will populate the price field for you.

Chuck

Link to comment
Share on other sites

This topic is 8528 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.