I am attempting to develop a QC DB for my international QC inspectors, in my dept we manage over 18,000 unique item id’s manufactured by over 400 factories, in 20 different countries . I keep a list of Item IDs and Factory IDs on a source of truth database which I have synced to my prototype inspection DB.
For Simplicity Sake, these two tables, within source of truth DB, are as follow,
Item IDs Table
Primary Field( ITEM IDS)
Secondary Field(Factory IDs-linked to Factory IDs table)
Factory IDs Table
Primary Field(Factory IDs)
Secondary Field(Item IDs-linked to item IDs table)
Within my inspection database, I’ve created 2 linked fields within the inspection table.
Filed One(Factory ID-linked to factory IDs)
Field two(Item IDs-Linked to item IDs)
I would like the QC inspector to enter a factory ID in field one… after which I would like the QC inspector to select an item ID in field two… And alas we reach the issue, how the heck to I configure field 2(item IDs) to only populate with item Ids associated with the factory ID selected in field one!!
Is this type of conditional linking do-able within Airtable? I would do this by having an outsourced data enterer create views for all factory IDs, but I cant seem to find a way conditionally link to views by referencing a field?
If not currently possible, has anyone heard through the grape vine if conditional linking and looking will ever be a thing?