Drop down selection question i have 2 tables...

[Siang_Teck_Beh]

Drop down selection question

i have 2 tables

Table 1 - Door list that contain all relevant information

Table 2 - Job entry that record the installation work of a door

How can i make sure 1 door only have 1 installation job?

When i create entry in Table 2, i have a dropdown list from table 1. How can i have dropdown that has the door with

job filtered out?

or i just record everything in table 1, then create a slice to have 2 information? However, this method will seems a bit hard if i wish to manage the Google Sheets itself.

Or any other way to do so?

[Aleksi_Alkio]

Try DoorTable[Door] - JobTable[Door]

[Siang_Teck_Beh]

@Aleksi_Alkio Not really understand what is this

[Aleksi_Alkio]

If you add it into the Valid_If, it will read doors from the DoorTable and then it subtract existing doors from your JobTable.