Hi there, a somewhat complicated issue today based on an InventoryTable with multiple foreign Keys.
The basic structure is that a PurchaseOrder is processed and creates multiple items in the InventoryTable. These Items are later packed into Packages, and the packages are later packed into Containers. The structure ends up having one container filled with multiple packages, and each package containing multiple items.
In each Item record there are three foreign keys called PurchaseOrderID, PackageID and ContainerID, so that the record looks something like this:
ItemID – Item Description – PurchaseOrderID – PackageID
the PACKAGE table shows:
PackageID - ContainerID
I want to make a PACKAGE form that can select multiple existing inventory items and ultimately put the New PackageID # into those Item records under the PackageID column.
When i do this now with comboboxes in a subform, I can only create NEW records where the items are repeated in the InventoryTable with a PackageID, but without the PurchaseOrderID. I want to simply edit the old existing records from the Inventory Table.
Is this a pipedream in Access or is it possible? Perhaps a multi-select listbox that can highlight existing records with some code that will apply the PackageID?
The basic structure is that a PurchaseOrder is processed and creates multiple items in the InventoryTable. These Items are later packed into Packages, and the packages are later packed into Containers. The structure ends up having one container filled with multiple packages, and each package containing multiple items.
In each Item record there are three foreign keys called PurchaseOrderID, PackageID and ContainerID, so that the record looks something like this:
ItemID – Item Description – PurchaseOrderID – PackageID
the PACKAGE table shows:
PackageID - ContainerID
I want to make a PACKAGE form that can select multiple existing inventory items and ultimately put the New PackageID # into those Item records under the PackageID column.
When i do this now with comboboxes in a subform, I can only create NEW records where the items are repeated in the InventoryTable with a PackageID, but without the PurchaseOrderID. I want to simply edit the old existing records from the Inventory Table.
Is this a pipedream in Access or is it possible? Perhaps a multi-select listbox that can highlight existing records with some code that will apply the PackageID?
