J
Jennifer
What I am trying to do is create a DB for users to enter
claim information. They will need to enter a serial
number on this claim. The DB needs to verify that this is
a valid serial number and then pull in the model number of
the unit. The user will also enter a part number that has
failed. The DB needs to verify the part number is valid
for that particular unit. So far I have a Part # Table, a
Model # Table, a Serial # Table, a Model/Part# Table and a
Claim Table. There will only be one serial number, there
can be many different models and many different parts per
model. The problem I am having is getting this DB
normalized and then getting a form created that verifies
all the data when it is entered. Any help would be
appreciated.
claim information. They will need to enter a serial
number on this claim. The DB needs to verify that this is
a valid serial number and then pull in the model number of
the unit. The user will also enter a part number that has
failed. The DB needs to verify the part number is valid
for that particular unit. So far I have a Part # Table, a
Model # Table, a Serial # Table, a Model/Part# Table and a
Claim Table. There will only be one serial number, there
can be many different models and many different parts per
model. The problem I am having is getting this DB
normalized and then getting a form created that verifies
all the data when it is entered. Any help would be
appreciated.