Need conditional dropdown of values - just need help making sure my relationship is correct.

[wfcperrine12]

How can this dropdown only be values of "subdivisions" that are located within the designated "county" designated above? 

Also would like to be able to add new records here if they don't already exist.

 

Secondarily and not as important.. I would love to have a type-ahead feature for this dropdown because I have over 1500 “subdivision” records.

TEST-SubsfromCounty.fmp12

[comment]

See if this simplified demo helps.

--
P.S. I am not sure why you need UUIDs (or IDs at all) for counties and subdivisions. I am sure their names are unique and I don't think they are likely to change. 

 

ConditionalVL.fmp12

[wfcperrine12]

You are probably right.  I've been brainwashed by Matt Petrowsy training about the UUIDs.  LOL