Jump to content
Sign in to follow this  
The Big Bear

lookup another field if first lookup is emtpy

Recommended Posts

Hi all

I have two db for welders. The first db is active welder and the second one is inactive welders.

The inactive welders are welders that are no longer working for the company. Some of the inactive welders created welding test to verify welding compatibility between the filler metal and the the base metal. I would like to removed thesse welder from the active db and install them in the inactive db but I still need to look up the inactive welders clock number, name, and stencil number when these welding test are printed for use. That would take a double look up. Is this Possible. Every thing I have tried have not worked.

Thank inadvance

Lionel

Share this post


Link to post
Share on other sites

Do I understand this correct, many criterias are working here, so if you deside to keep every welder in the same base dispite having left? Could a single attribute make you use this:

http://www.filemaker.com/help/FunctionsRef-316.html

Provided the structure really needs a lookup, a sorted live multi-criteria relation might be enough?

--sd

Share this post


Link to post
Share on other sites

Hi SD

Yes, I could but the active db has a lot of active being preformed in it. I would not want to shown these welders when these active are be performed. I know I can write a find script and only show the omitted records. But it would be simplier in the long run if the welder were removed from the active db.

Thanks, I will look into what you said.

Lionel

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  

×

Important Information

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