Jump to content
Sign in to follow this  
oilman

Is relookpu what i want?

Recommended Posts

Hi all

My welder's qualification form has two colunms for entering two different welding processes. When a process is chosen from a pop-up list, Two other lookup fields are populated. Sometimes a welder is qualify using only one process and sometimes the operator populates the second process field invertly and then goes back and delete the process but the lookup fields have been populated. I have tried doing a relookup but i must not understanding which field must be relookup because the lookup fields stay populated. How can i unpopulated the lookup fields.

Thanks in advance

Lionel

Share this post


Link to post
Share on other sites

Make the two other fields calculated rather than lookup. Then if the first field is changed, so will the two other fields.

Share this post


Link to post
Share on other sites

Thanks transpower

But that is not acceptable because the pop list is base on another database because different companies add abbreviation to the industries standard name for the welding process. If one company changes the pop up list than that section of the program will not work.

Lionel

Share this post


Link to post
Share on other sites

Lionel:

Include a [none] record in the value list database. So if a field has a welding process and you actually want [none], choose [none] from the value list, which can then be used in the other field.

Another idea (if you could use version 7) is to enclose your current lookup function within an evaluate function with the fields you want to use as triggers for a relookup.

Still another idea: from the Records menu, you can relookup field contents for the found set.

Share this post


Link to post
Share on other sites

Hi

I have tried relookup from the Records menu and the second field does not go blank when the first filed is empty.

Share this post


Link to post
Share on other sites

The relookup must be performed from the match field, not the target or source field.

Share this post


Link to post
Share on other sites

There is also an option to return a particular result or nothing if the looked up field is empty.

Share this post


Link to post
Share on other sites

Hi all

that the problem. When the match field is populated then the relookup works. But when the match field is empty,the lookup field that populated does not change, the relookup does not work. I have even included a empty record in the db where the lookup ocurr.

Thanks

Lionel

Share this post


Link to post
Share on other sites

Deselect "Don't copy contents if empty" and select "If no exact match, then:", select 'use' and don't enter anything into the box.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    DaCo 
×

Important Information

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