good day,
I am here again seeking help for my db... As per title, is this possible?
What I am trying to achieve is an update for the purchase request, becoming a purchase order.
I was hoping that in purchase order form I will only input the purchase request number as a lookup and the textboxes in the form for the fields will be populated as what is saved in TblPurchaseRequest.
The Difficult part now is that I am trying to add a Datasheet subform in the Purchase order form where the lookup will be from Purchase Request number and LOT number. The datasheet will be populated with the data depending on what LOT in that Purchase Request like Unit, Item Description, quantity and cost, but the Quantity and cost will be editable as that value is subject to change in Purchase Order.
after all the data after lookup and being edited, I was also hoping that being the lookup, it will not affect the data from what table is it from, but will be saved in the different table like TblPurchaseOrder, TblPOLot, and TblPOLotDetails.
Prior to this post, I have been searching the net, but I am stuck at populating the datasheet subform with editable value and saved in different table...
I am sorry for bothering but I am in desperate need of expert help for the db, this is actually my 1st db, I migrated to access because excel has limitation and loads slow when there are already to many tables, data, automation computations..
Thank you in Advance...
I am here again seeking help for my db... As per title, is this possible?
What I am trying to achieve is an update for the purchase request, becoming a purchase order.
I was hoping that in purchase order form I will only input the purchase request number as a lookup and the textboxes in the form for the fields will be populated as what is saved in TblPurchaseRequest.
The Difficult part now is that I am trying to add a Datasheet subform in the Purchase order form where the lookup will be from Purchase Request number and LOT number. The datasheet will be populated with the data depending on what LOT in that Purchase Request like Unit, Item Description, quantity and cost, but the Quantity and cost will be editable as that value is subject to change in Purchase Order.
after all the data after lookup and being edited, I was also hoping that being the lookup, it will not affect the data from what table is it from, but will be saved in the different table like TblPurchaseOrder, TblPOLot, and TblPOLotDetails.
Prior to this post, I have been searching the net, but I am stuck at populating the datasheet subform with editable value and saved in different table...
I am sorry for bothering but I am in desperate need of expert help for the db, this is actually my 1st db, I migrated to access because excel has limitation and loads slow when there are already to many tables, data, automation computations..
Thank you in Advance...