Hi,
I have made 3 forms, details,master, and stocks. They r based on same name tables i.e., details, master and stocks.
Stocks has got a set of pre-loaded records. I want to show data related to stocks on details form, but it should only happen when anyone enters some data in a CODE field on details form. Basically there are 3 fields which are same in details and stocks. CODE (NUM), PONO (TXT), DESC (TXT).
My query is, that when a user enters a record in CODE field it should check if the same code exist in stocks table. If yes then it should fetch the other two fields data and paste in details form. Also advise me how to link these three table together. Please Help
I have made 3 forms, details,master, and stocks. They r based on same name tables i.e., details, master and stocks.
Stocks has got a set of pre-loaded records. I want to show data related to stocks on details form, but it should only happen when anyone enters some data in a CODE field on details form. Basically there are 3 fields which are same in details and stocks. CODE (NUM), PONO (TXT), DESC (TXT).
My query is, that when a user enters a record in CODE field it should check if the same code exist in stocks table. If yes then it should fetch the other two fields data and paste in details form. Also advise me how to link these three table together. Please Help
