Using generic parts field in database

  • Thread starter Thread starter John
  • Start date Start date
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
 
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
 
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
 
Back
Top