Active / inactive question

[dtrots]

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

[BobWeaver]

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.

[dtrots]

Thank you, worked perfectly.