T
tina
the short answer is - you shouldn't do it. the point of a
relational database is that you don't store duplicate data.
you have a list of units with an inventory number as a
primary key, in your keylist table. as long as you save
that primary key in the record you enter in the keylog
table, that's all you need.
whenever you need to see the additional info connected
with a specific inventory number, link the keylist and
keylog tables in a query via the inventory number.
relational database is that you don't store duplicate data.
you have a list of units with an inventory number as a
primary key, in your keylist table. as long as you save
that primary key in the record you enter in the keylog
table, that's all you need.
whenever you need to see the additional info connected
with a specific inventory number, link the keylist and
keylog tables in a query via the inventory number.