I have a warranty claim form with a part subform that pulls description and
pricing information from a linked table. The database will not let me enter
a part number that is not in the linked table. I need to, on certain
occassions, be able to enter a part number that is not in this table.
However, I would like to store it in another seperate table.
Here is the scenerio:
We have two factories that produce two different products. I have access to
the parts database tables at one of these factories. I process warranty
claims for both. Therefore, if I get a claim on a machine from the other
factory, I need to be able to keep track of part numbers from that factory,
even if that means I have to enter the pricing information and description
manually.
Any suggestions?
Thanks for the help.
Shannan
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200603/1