Conditional Value List

Discussion created by struggling on Apr 19, 2017
Latest reply on Apr 19, 2017 by philmodjunk

Hi All,


I'm having a problem with creating a conditional value list that shows only the records in a table that are marked "available" via a radio button set on a related table layout.


Basically I'm a yacht broker creating my own database as follows:

1 VESSEL may be listed many times

1 SELLER may have many listings --- Join table between the SELLER and VESSEL = LISTING

1 LISTING may have many SELLERs--- Join table between SELLER and LISTING = LISTINGSELLERJOIN

1 new contact LEAD may enquire about more than one LISTING  -- Join table between LEAD and LISTING = ENQUIRYJOIN


Once a vessel has been sold, the LISTING "Active" field is marked "Sold" via a radio button set.  If this vessel becomes available for sale again, I create a new listing for the vessel and the "Active" field has an auto-enter data field that sets it to "Available".


What I want to do is only show the "Available" LISTING in the ENQUIRYJOIN layout when a LEAD enquires about the new listing.


I hope this all makes sense.  Any help would be greatly appreciated.