AnsweredAssumed Answered

Multiple Lookups, Help Please !

Question asked by DaveDave on Sep 21, 2012
Latest reply on Sep 21, 2012 by philmodjunk

Title

Multiple Lookups, Help Please !

Post

     Hi All, Manged to get a good looking service report going with lots of little tricks but need help on the last part of the form, which has been bugging me for weeks and cant find an answer.

     I have three columns -  Qty, Items,  Cost.

     this is then repeated ten times. for ten separate items.

     What I'm trying to achieve is some form of look up. from another table.

     Click on the Items box and that in turn produces a drop down list of parts from a separate table ( Parts Table ). When the part is selected it automatically puts in the price in the cost column. ( Cost will come from the Parts Table )

     I assume I should be using the look up command in someway, but don't know how to implement it.

     Any help much appreciated.

     Thanks

     Dave

      

Items_Form.png

Outcomes