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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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