In 2018 a line with a unique id (UUID), something that looks like wcvjj455-wd356x-Loy589, has a title of something like “Flu test kit”.
In Table_B I have the invoices.
It’s a table full of UUIDs from other tables. Now if I didn’t use a lookup feature in Table_B to record the title of item wcvjj455-wd356x-Loy589, then the title is fluid. If then in 2020 I rename our “Flu test kit” in Table_A to “COVID 19 test kit” then Table_B will show the change when you bring up an old invoice.
Where this is utilized is if I have a spelling error, I can go to 1 pace in 1 table and correct the error and it will correct the error across the entire database.
Table_B doesn’t know “Flu test kit”, unless it’s told to record it, it only knows wcvjj455-wd356x-Loy589.
Now IF this is the case it means that the COVID test kits are just flu test kits, or some other already existing test kit rebranded.
Databases.
In Table_A I have all the items we sell.
In 2018 a line with a unique id (UUID), something that looks like wcvjj455-wd356x-Loy589, has a title of something like “Flu test kit”.
In Table_B I have the invoices.
It’s a table full of UUIDs from other tables. Now if I didn’t use a lookup feature in Table_B to record the title of item wcvjj455-wd356x-Loy589, then the title is fluid. If then in 2020 I rename our “Flu test kit” in Table_A to “COVID 19 test kit” then Table_B will show the change when you bring up an old invoice.
Where this is utilized is if I have a spelling error, I can go to 1 pace in 1 table and correct the error and it will correct the error across the entire database.
Table_B doesn’t know “Flu test kit”, unless it’s told to record it, it only knows wcvjj455-wd356x-Loy589.
Now IF this is the case it means that the COVID test kits are just flu test kits, or some other already existing test kit rebranded.