Jump to content
Sign in to follow this  
James Blachford

How do I filter popup menu results

Recommended Posts

Hi

Thanks for reading my post.

I am building a CRM and Job management system. It is split ino four sparate dbase's.

Customers

Quotes

Job Management

Purchase Orders

I have all the suppliers and customers in the Customers section. I have a field which is a radio button set so when the user adds a record they select if it is a prospect, customer or supplier.

I have successfully added the lookup field and pre-filled company detail fields in my purchase order database. I need to filter the companies on the popup menu of the company name popup field in the purchase order database to only show companies that have the radio button supplier selected.

Can anyone help or advise?

Thanks

Jimbob

Share this post


Link to post
Share on other sites

You need to filter the value list for only suppliers. Set a global text field with the string "supplier". Create a relationship from this field to the type field (prospect, customer or supplier) and then create a value list based off that.

Share this post


Link to post
Share on other sites

hi Mr Vodka

Thanks for your reply, I'm not sure I get you correctly. My biggest problem is that the list of companies is matched with a company number value. And the value list shows data from only the second field which is the company name.

The databases are completely separate files.

Will this option still work?

Share this post


Link to post
Share on other sites

Yes to your first question. As long as a TO of the other file's table is on the relationships graph you can still make the relationship work rather easily.

As for your second question. There is no generic answer to whether one file or multiple files should be used. Depending on the amount of data, solution structure, business model, etc it could vary from solutions to solution. In your case, it seems that you could use one file.

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.