H
HW
First and foremost, I'm a novice. My ideas of database
design are limited.
I am in charge of tracking several hundred pieces of old
machinery which are scattered around the country. I have
a table that identifies the machinery, serial number,
model,location, and person to contact. This table is
referred to as Machinetbl.
Several times a year the manufacturer or some other
company creates a modification or recall that should be
applied to all the machines. These recalls can come in
three methods. Technical Reports, Safety Messages, or
Modification Instructions. I've created a table for each
of these with a description, date, and what is affected.
These are generally referred to as Messages. Each one has
a unique number and is currently the primary key for each
table. They will never be alike.
I would like to have the database apply all three types of
messages(totaling about 200 in archived records)to all the
machines and have a check box indicate if it was complied
with a particular serial numbered machine.
Currently, I believe I need a way to add a record to one
of the message tables and have it automatically add a
field with the message number to the machine info table.
Is this possible? Is there a better way to tackle this?
If so, how would I force the newly generated field to
default to a check box (Define the properties of the newly
generated field).
My VB is marginal at best. I can barely spell it
correctly, but I'm willing to learn.
I have a fancy book on Access (Access 2002 Inside Out),
but haven't found what I'm looking to do.
Any help would be greatly appreicated. Thanks!
design are limited.
I am in charge of tracking several hundred pieces of old
machinery which are scattered around the country. I have
a table that identifies the machinery, serial number,
model,location, and person to contact. This table is
referred to as Machinetbl.
Several times a year the manufacturer or some other
company creates a modification or recall that should be
applied to all the machines. These recalls can come in
three methods. Technical Reports, Safety Messages, or
Modification Instructions. I've created a table for each
of these with a description, date, and what is affected.
These are generally referred to as Messages. Each one has
a unique number and is currently the primary key for each
table. They will never be alike.
I would like to have the database apply all three types of
messages(totaling about 200 in archived records)to all the
machines and have a check box indicate if it was complied
with a particular serial numbered machine.
Currently, I believe I need a way to add a record to one
of the message tables and have it automatically add a
field with the message number to the machine info table.
Is this possible? Is there a better way to tackle this?
If so, how would I force the newly generated field to
default to a check box (Define the properties of the newly
generated field).
My VB is marginal at best. I can barely spell it
correctly, but I'm willing to learn.
I have a fancy book on Access (Access 2002 Inside Out),
but haven't found what I'm looking to do.
Any help would be greatly appreicated. Thanks!