R
RAM
Hi, Group! Good day!
One of my officemates is tasked to do an inventory database using access
2000. He asked me to assist him though my knowledge in Access is very very
limited. He has tables namely Products, Supplier Transactions, Client Orders.
Table fields are as follows:
PRODUCTS - ProductCode (Pkey - text), ProductName (text)
SUPPLIER TRANSACTIONS - TransNumber (Autonumber - PKey),Date,SupplierCode,Qty
CLIENT ORDERS - PO#(PKey -
text),InvoiceNumber,OrderDate,ShipDate,QtyRequired,QtyShipped
What he did was make a Supplier Transactions Form which he wants to make the
data entry point form. He also made a Main Form named Products with unbound
textboxes namely TOTAL ORDERS OF CLIENTS, TOTAL DELIVERIES OF SUPPLIERS then
immediately below is a Tab Control containing 2 subforms namely CLIENT ORDERS
and SUPPLIER DELIVERIES. Now, he wants the data entered from the Supplier
Transactions Form to be automatically inserted into the subforms.
I can think of using a Look Up Wizard to build additional tables namely
PRODUCTS SUBFORM CLIENT ORDERS and PRODUCTS SUBFORM SUPPLIER DELIVERIES. But
I myself is confused how to do this. Any other suggestions?Please help us.
Thank you very much!
Sorry for the lengthy post but I think I have to recreate and give the full
details of the problem. Again, thank you so much for your time and effort
helping us.
One of my officemates is tasked to do an inventory database using access
2000. He asked me to assist him though my knowledge in Access is very very
limited. He has tables namely Products, Supplier Transactions, Client Orders.
Table fields are as follows:
PRODUCTS - ProductCode (Pkey - text), ProductName (text)
SUPPLIER TRANSACTIONS - TransNumber (Autonumber - PKey),Date,SupplierCode,Qty
CLIENT ORDERS - PO#(PKey -
text),InvoiceNumber,OrderDate,ShipDate,QtyRequired,QtyShipped
What he did was make a Supplier Transactions Form which he wants to make the
data entry point form. He also made a Main Form named Products with unbound
textboxes namely TOTAL ORDERS OF CLIENTS, TOTAL DELIVERIES OF SUPPLIERS then
immediately below is a Tab Control containing 2 subforms namely CLIENT ORDERS
and SUPPLIER DELIVERIES. Now, he wants the data entered from the Supplier
Transactions Form to be automatically inserted into the subforms.
I can think of using a Look Up Wizard to build additional tables namely
PRODUCTS SUBFORM CLIENT ORDERS and PRODUCTS SUBFORM SUPPLIER DELIVERIES. But
I myself is confused how to do this. Any other suggestions?Please help us.
Thank you very much!
Sorry for the lengthy post but I think I have to recreate and give the full
details of the problem. Again, thank you so much for your time and effort
helping us.