This type of field Looks up its value only when the Link ID/Value controlling its lookup is created or deleted/recreated in the same table. Ie, change the Link ID and the field re-looks up if you need it to.
Use case: Staff Table/Record holds field: pay rate per hour. Each Shift record has a lookup field for the Staff pay rate field. Over time, admin adjusts the Staff record pay rate(hopefully up!), but traditional lookup fields will now update in all Shift Records containing that Staff ID - innacurate data salad.
Having a one-time lookup solves this as well as a myriad of other use-cases like using Templated data in one table to help create new records in diff tables (all new data in other tables is looked up AND then editable).
Thank you!
