Link to another record - only able to look up Primary field?


#1

Hello all,

We use Airtable to manage our auto export business, mainly for keeping track of documents in/out and car movements from one warehouse to another.

I’m trying to create a table where we can keep track of where / when / who happened to the docs

It is linked to our Master table which has all the main vehicle info (vin / make / model / customer / price…etc) , but our Master table has a “stock number”(autonumber) as Primary field.

When I setup a new table called Doc Tracking, then Link to Master, when you add a record, it only looks up the Primary field, but not able to search by partial vin.

It’s kind of cumbersome to enter by “stock number”, which we only use for filing purpose. we always go by the VIN for everything else.

Is there a way to define which field the “Link to another Record” looks up?

Thanks


#2

No, but you can set the Primary Field as a Formula, to combine other fields values.