Good day,
1st of all, sorry that my Subject is very broad. Attached is the DB I just created with the help from this wonderful forum's experts... I am now again seeking your expertise.
The DB is running smoothly, but then I encounter a problem... The way this DB works is that 1st to record the Purchase Request. Categorizing the Items through LotID or LotNumber. Then when it is been processed to being a Purchase Order, the form TblPurchaseOrder will do lookup for the PR and LotID, then in the subform the items will appear and will be edited by what the Purchase Order has like the quantity and cost.
Now my problem arise when in a single LotID the Items were not in a single Purchase Order, when it is for different supplier which will have another Purchase Order. I would like to seek advice on a workaround on this... I was thinking when in filling the Purchase Order form after the LotID, a new window will open and it will populate all the Items in a LotID then each item will have a checkbox where I can select the items only included in the Purchase Order before they will be recorded in the table...
I am very sorry for this, I just can't find any solution in the net regarding my concern... For now I am watching some video tutorials hoping I could find some solution from there...
1st of all, sorry that my Subject is very broad. Attached is the DB I just created with the help from this wonderful forum's experts... I am now again seeking your expertise.
The DB is running smoothly, but then I encounter a problem... The way this DB works is that 1st to record the Purchase Request. Categorizing the Items through LotID or LotNumber. Then when it is been processed to being a Purchase Order, the form TblPurchaseOrder will do lookup for the PR and LotID, then in the subform the items will appear and will be edited by what the Purchase Order has like the quantity and cost.
Now my problem arise when in a single LotID the Items were not in a single Purchase Order, when it is for different supplier which will have another Purchase Order. I would like to seek advice on a workaround on this... I was thinking when in filling the Purchase Order form after the LotID, a new window will open and it will populate all the Items in a LotID then each item will have a checkbox where I can select the items only included in the Purchase Order before they will be recorded in the table...
I am very sorry for this, I just can't find any solution in the net regarding my concern... For now I am watching some video tutorials hoping I could find some solution from there...
Attachments
Last edited: