AnsweredAssumed Answered

autofilling an order form from an inventory table

Question asked by IanGentle on Jun 6, 2013
Latest reply on Jun 7, 2013 by philmodjunk


autofilling an order form from an inventory table


     Hi everyone,

     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.