I’m having trouble with a DropDown…
I have a table of properties (tprop) with fields propid (ID), propadd (address), propblock (block ID) and proptype (property type).
propid is generated random string
propadd is addid from tadd
propblock is propid from tprop
proptype is typeid from ttype
2nd table (tadd) with fields addid, add1, add2, addpc (postcode)
addid is generated random string
add1, add2 and addpc are all text
3rd table (ttype) with fields typeid, typename, typetype
typeid is generated random string
typename is text
typetype is typeid from ttype
I have a form to create a new property and one of the drop downs is a list of properties with type “block”.
I managed to get a list of propid’s from tprop of just the properties that have proptype “block” but I really want to see add1, add2, addpc in the dropdown list so I can see what I’m choosing.
Hope that all makes sense, check out what I’ve done here https://aafisher.bubbleapps.io/version-test