Jump to content
Sign in to follow this  
Frasier13

Pop-up menu

Recommended Posts

Hi there

I've been using FM now for about 2 years on and off mainly to produce databases primarily to manage my own projects and i'm self taught with no formal training.

This is what i'm trying to do.

I have two tables "JOBS" and "CONTACTS".

One of the fields in "CONTACTS" is "working status". This is a pop-up menu with a value list assigned to it with the following values:

  • Make initial contact
  • Follow up
  • Not interested
  • Potential collaboration
  • Working together

In "JOBS" I want to create a pop-up menu of "CONTACTS" but I only want to list those that have a "working status" set to "Working together".

Hope this makes sense.

Regards

Share this post


Link to post
Share on other sites

There are a few ways to do this. The first way would be to create a calculation field on contacts that is Case ( working status = "Working together"; ContactName ) and then you can take the value list from that.

Or, you can create a global field that you can set to store the data, "Working together" and then create a new relationship from this global field to the sorking status field. Then reference the ContactName field via this new relationship in your value list. This is my preferred method.

Share this post


Link to post
Share on other sites

It's amazing how easy something is when your given a little direction (in this case the whole route). I have spend about 15 hours in total trying to figure out how to do that before I came on here to ask... so thank you very much. Took me less than 15 minutes in the end!!!!

Just for the record I opted for your first suggestion only because im still trying to get to grips with relationships and I just needed to get this up and running short term. However, I am going to set about doing your suggested way over the weekend.

Once again thanks very much.

Regards

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.