Jump to content

Active / inactive question


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

Recommended Posts

I have a Vendor database that I have set up radio buttons to show active or inactive. I have the hoices manually put in in the field format.

I have a separate database for invoices. I have a menu field for the vendor name but I only want it to show active vendors from my vendor list.

Sorry if this has already been asked or answered but I am stuck.

Dave

Link to comment
Share on other sites

Assuming the Status field in your vendor database contains the value "active" to indicate that it's active, create a calculated field in your inventory database called cActive = "active"

Now create a relationship from the inventory database to the vendor database called ActiveVendors. For the link, select cActive from the lefthand list and the status field on the righthand list. You now have a relationship that will select only active vendors. Next format the value list for your vendor menu as: "use values from field," Specify: "only related records." Select the ActiveVendors relationship from the popup menu, and pick the vendor name field from the list of fields.

Link to comment
Share on other sites

This topic is 8543 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
×
×
  • Create New...

Important Information

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