Unique ID on Things

Is it possible to use the “unique id” to reference a data record. By that I mean if I the following files

ITEM FILE
SKU
BARCODE
SUPPLIER UNIQUE ID
UNIQUE ID

SUPPLIER FILE
CODE
NAME
UNIQUE ID

With the above situation I could change the supplier CODE without worry where the supplier is referenced because it uses the UNIQUE ID, is that correct?

In the situation you referenced:

you do have an ability to change the supplier code without worry, however it is not necessarily the optimal set up to use the supplier unique id as a text field.

Instead make the supplier unique id just be a supplier filed data type

Am I correct in thinking that if I have the supplier code in the item record and then I go in the database and decide to change the supplier code in the supplier field within the supplier database the supplier code will automatically be updated in the item file, that is awesome if that is the case

It is not the case because your text field you call supplier code in the item is just a text and not related to anything.

This topic was automatically closed after 70 days. New replies are no longer allowed.