Jump to content

Check box calculation


This topic is 5766 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hey there-

I have a table in my database designed to maintain all of my company's contacts. The table contains a checkbox field with the options "Client", "Consultant", "Vendor" and "Other". Because we have contacts that are both a client and a consultant, I have to maintain the field as a checkbox set.

In my projects table, though, I want to be able to show values lists of clients and consultants separately. i.e. Where the user can choose a client for any given project, I want a drop down list of clients only. My idea was to create a calculation field in the Contacts Table, which I could then use to create a dynamic value list.

e.g. Case(Contact_Type = "Client", Client_Name = "Company_Name"; "")

The problem is that this doesn't ultimately include the contacts for which both "Client" and "Consultant" is checked. Does that make sense? Any suggestions?

Thanks for the help.

Link to comment
Share on other sites

This topic is 5766 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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