Y
yanela
Hello.....
I have Categories, Products, Order Details, Orders and Employees tabl
in my database. All of the tables have primary keys and is on a one t
many relationship. Employees table is linked to ORDERS in a 1 to man
relationship and ORDERS table is linked to ORDER DETAILS one to man
relationship then PRODUCTS table is linked to ORDER DETAILS one to man
relationship. On the Order Details table, I have Order Id, Unit Pric
Quantiy In and Quantity Out fields.
I am a newbie to Microsoft Access programming. I would like to know ca
I make a Item Entry field a user can enter the employee ID number tha
will open up a form where Order details fields are there but are blan
ready for appending. That form will be open up for that employee only
There would be a save button that will save the items added on th
blank fields.
I would also like to add that there will be a label from the form abov
that will automatically substract Quantity-Out when an entry fo
Quantity Entry is made. The Quantity Out and Quantity In can hav
different dates. If a value in Quantity In is entered but greater tha
Quantity Out, it will not be accepted. A prompt will appear.
I feel that using Access can do this and with your expert help in thi
newsgroup, I can make this possible.
Thanks for all your help
I have Categories, Products, Order Details, Orders and Employees tabl
in my database. All of the tables have primary keys and is on a one t
many relationship. Employees table is linked to ORDERS in a 1 to man
relationship and ORDERS table is linked to ORDER DETAILS one to man
relationship then PRODUCTS table is linked to ORDER DETAILS one to man
relationship. On the Order Details table, I have Order Id, Unit Pric
Quantiy In and Quantity Out fields.
I am a newbie to Microsoft Access programming. I would like to know ca
I make a Item Entry field a user can enter the employee ID number tha
will open up a form where Order details fields are there but are blan
ready for appending. That form will be open up for that employee only
There would be a save button that will save the items added on th
blank fields.
I would also like to add that there will be a label from the form abov
that will automatically substract Quantity-Out when an entry fo
Quantity Entry is made. The Quantity Out and Quantity In can hav
different dates. If a value in Quantity In is entered but greater tha
Quantity Out, it will not be accepted. A prompt will appear.
I feel that using Access can do this and with your expert help in thi
newsgroup, I can make this possible.
Thanks for all your help