Hello all,
I've been reading this group for a while now in preparation for my first access project, and now I've run into a problem.
I'm setting up a Purchase Order database that will store my company's items, purchase orders, and vendor information. The underlying structure is as follows:
Each item will have basic information such as an item code, category, etc. which will be stored in an Items table.
Some items can be acquired from multiple vendors, so the items table has a 1-to-many relationship to a table (ItemVendorDetail) which stores the VendorID (Linked to a main Vendor table), VendorItemCode, and cost.
There are also a PurchaseOrder table and a PurchaseOrderDetail table.
The PurchaseOrder table has a 1-to-many relationship with the PurchaseOrderDetail table.
My problem arises when I design the PurchaseOrder entry form.
I have a main form derived from the PurchaseOrder table, with fields such as PO#, Date and Vendor. I have a subform linked to the main form where I enter the details of the purchase order, such as ItemCode, Quantity, etc. I need to display information in the subform from three tables: the PurchaseOrderDetail table, the Items table, and the ItemVendorDetail table. I can access the data correctly, and can create the query that produces the correct data, but I can't update or add records, therefore I can't add purchase orders.
I apologize for being so long-winded, but I would appreciate any help at this point.
Regards,
Julio
I've been reading this group for a while now in preparation for my first access project, and now I've run into a problem.
I'm setting up a Purchase Order database that will store my company's items, purchase orders, and vendor information. The underlying structure is as follows:
Each item will have basic information such as an item code, category, etc. which will be stored in an Items table.
Some items can be acquired from multiple vendors, so the items table has a 1-to-many relationship to a table (ItemVendorDetail) which stores the VendorID (Linked to a main Vendor table), VendorItemCode, and cost.
There are also a PurchaseOrder table and a PurchaseOrderDetail table.
The PurchaseOrder table has a 1-to-many relationship with the PurchaseOrderDetail table.
My problem arises when I design the PurchaseOrder entry form.
I have a main form derived from the PurchaseOrder table, with fields such as PO#, Date and Vendor. I have a subform linked to the main form where I enter the details of the purchase order, such as ItemCode, Quantity, etc. I need to display information in the subform from three tables: the PurchaseOrderDetail table, the Items table, and the ItemVendorDetail table. I can access the data correctly, and can create the query that produces the correct data, but I can't update or add records, therefore I can't add purchase orders.
I apologize for being so long-winded, but I would appreciate any help at this point.
Regards,
Julio
