How to get a value from a datamaster into another datamaster
Hey! So I'm making a store administrator prototype app and I have two datamasters: Billing and Stock, so in stock I have all the records of the products names with its prices. I have a billing page where I can type a product's name and quantity and save that record into the billing datamaster, so the question is: How can I get the price of such product and then have it displayed in the billing datamaster? It's kind of the equivalent of Excel's VLOOKUP function. I have tried using the filter function but nothing comes out of it.