Limit Selection

[swsw]

Hey everyone,

in the same base,

I have 1 table with a list of account names.
I have 1 table with a list of property names (with a field to denote the account name that owns the property)

In a 3rd table, I now want to be able to select an account name and ONLY see the property names associated with the account name selection.

How would I go about this?

[Justin_Barrett]

Welcome to the community, swsw! :grinning_face_with_big_eyes: I think the setup described in this post will get you where you want to go:

Conditional Logic-ish Linked Records Show and tell

TL;DR version: Airtable’s recently added capability to limit linked-record selection to a specific view allows users to incorporate, to a degree, conditional logic. The specifics: ‘Conditional logic’ can mean a lot of things: Any use of an IF() or SWITCH() statement is a form of conditional logic. Here, I’m using it in what’s become an increasingly common manner: to mean the limiting of available options based on an earlier choice. For example, take a look at the following diagram. [Condition…