New to Access: Order Form Help

[Cohdy]

Hi Everyone,



I was looking for some assistance in building a Purchase Order Generator with a few tables of data that I have on hand and will continue to update.

I would like for the build to be capable of doing the following:

• Users would need to login with a username and password before gaining access to the form.
• Each user would have a specified account number and customer name tied to that user.
• When opening the Order Form the user's account number as well as their company name would be prepopulated in designated fields in the form
• I would like to be able for a user to write in the part number field and have the description automatically populate (almost like a vlookup in excel). Except I would like for the customer to write in a part number or a manufacture part number of the product from the catalog table and have the corresponding description return in the description field. Alternatively, if a user writes in "Non-Stock" I would like them to have the freedom to write in their own description.
• I am also trying to make the order lines portion auto generate another line if an initial line has been filled out.

I've made a few tables and a few forms, but I don't think I've gotten very far. Is there someone who might be able to point me in the right direction with this? I will continue to explore the forum in the meantime. Please see screenshot of current progress below:




I appreciate any help!

- Cohdy

[ranman256]

youre item detail form is wrong. Dont use detail form, it should be a CONTINUOUS FORM so user can add infinite amount of entries.

tblOrder: order master tbl
--------------------
OrderID (autonum)
OrderDate
CustomerID (bound to customer tbl)
etc


tblOrderDetail : all items in the order
---------------
DetailID (autonum)
ItemNum
ItemDescr
Qty
Amt

[Welshgasman]

Might want to have the OrderNum in the detail record as well?

[Cohdy]

I'll give it a go! Thank you for your direction. I bought a course on Udemy that I think will be a great help.

youre item detail form is wrong. Dont use detail form, it should be a CONTINUOUS FORM so user can add infinite amount of entries.

tblOrder: order master tbl
--------------------
OrderID (autonum)
OrderDate
CustomerID (bound to customer tbl)
etc


tblOrderDetail : all items in the order
---------------
DetailID (autonum)
ItemNum
ItemDescr
Qty
Amt

[mike60smart]

Hi Cphdy
Can you upload a copy of your database when you have revised the tables?