Search results

What would be the PK for the TblLot if I make it the PK in TblLotParticular...?

Am I deleting the TblLot?

good day... I am sorry for that my DB is a mess... its my 1st DB ever made and I only learned to make this tru tutorial videos and from this forum... If its not to much trouble, may you help me... The table relationship is very messy... Please... Thank you... The step on my work is 1st...

Thank you sir... will look into it...

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...

ok sir... thank you very much.... My db is slowly progressing now... thanks to the masters here... For now, I will be designing my report...

Thank you sir... But it was supposed to be empty, but I don't know why it becomes 0...

There seems to be a problem sir... the code did not work on my last Purchase Request on the REquest 19-02-010, the POQuantity runs 0

Hope I am not misunderstood, a while ago I was searching of doing the Do Until and loop as an afterupdate in the LotID combobox, where when I select from LotID, the TblLotParticular subform1 will do a lookup in the TblLotParticular table LotID as the criteria and it will be displayed in the...

Thank you sir.. The way it works is only when I am entering data in Request...

It is because in the Purchase Order, cost and sometimes the quantity is changed... They are tend to be changed because Purchase request values are all just estimates, unlike in purchase order the cost is the correct amount... Thank you for this... I will try again to analyse this and apply in...

good day, I am confused with two advices from the masters, but I would like to prefer theDBguy since it will save file size. I have tried applying it, then link relationships to IDs, but after data is entered, the related field has no input or value... I am just worried because I might not be...

good day sir, May you help me how to code using ur advice from my thread? the code for populating the subform... sorry for the bother sir... https://access-programmers.co.uk/forums/showthread.php?t=303366

you might notice that the POID in the TblLotParticular is in lookup, it was because I am trying to replace it coz the 1st time I made it just a number, access does not auto input the POID from TblPurchaseOrder form...

Good day, I have attached my db... so far it is where is have accomplished so far...

Good day, Is it possible to have 2 or more foreign key in 1 table? I am talking about a foreign key that is not created by lookup, but by relationships, where when I enter data, it will be automatically valued in the assigned table.. My concerned is in TblLotParticular, foreign keys are PRID...

Hello sir, May you advice me on how to do it? May I also seek help on my TblLotParticular, I made relationship on PRID but in the table, PRID is blank...

Thank you for the reply, will try to analyze this advice and try to apply... Will get back if I failed to apply...

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...

May I ask guidance on how to apply what is advised? Thank you...