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.