Recent content by nikhilstephen

So Can I enter data into a query?? just like I save records to a table?

Hi, I have a table called Inventory and Transactions. I want to create a form where I read certain product detail from Inventory,add details like Date,quantity etc. and save the whole record to the Transaction table. Can I retrieve linked values? eg. Product AND its price,from the Inventory...

Thank you so much for sharing the answer to this! I was looking for a function to do the exact cleanup.