Using generic parts field in database

J

John

I have a problem it that I need to be able to enter in miscellaneous parts
for jobs and orders. I currently have a products table and select items from
this for orders. I have seen a system where a particular code can be entered
that will allow a user to manually enter a description and price for a
particular item. How would this be achieved in access.

Any help greatly appreciated

John
 
M

MChrist

John,

I would handle that situation by creating a generic part # like 9999 that
whenever I would enter it into my form would unlock the part description
field. You'll also need to create an AfterUpdate event in the part # field
of your form to handle this.

Mark
 
J

John

Thanks for your suggestion. Would you store it in the normal product table.
The product code field in my product table is set as unique. My problem is ,
for instance "sundries" may need to be entered many times with different
prices each time.

John
 
Top