autofilling an order form from an inventory table
I am at best an amatuer filmaker user, but never the less am responsible for maintaining some databases for my laboratory to track our chemicals and so on. I am trying to set up an ordering and inventory database for the lab. I want it to be fairly basic, just so the lab members can request items from the inventory be ordered and then a list of all the orders and their status be generated. I have made three tables, one for inventory, one for the order form itself, and one which I want to act as a list of all orders that we can use to see which ones have been ordered and received etc.
What I would like to do is have a button on the order form that we can use to search for items in the inventory and then select the found result and use it to autofill the order form. I just can't seem to figure out how to do this. I must admit that my script writing is limited at best. If anyone has an idea of how to implement this I would be greatful.