0 Replies Latest reply on Feb 20, 2009 1:59 PM by Sewlong

    Auto Enter - Look up Multiple Values



      Auto Enter - Look up Multiple Values


      I have one table called “items” that stores the generic information about the products we make.

      Then when we are ready to make one of the items I have a table called “projects” and it simply looks up and copies the information from the “Items” table into the “Projects” table (based on a record #) and we then can add/modify the specific details about that particular “Project”.


      I also have a table "Join-Item-Material" that joins the generic “Items” to the multiple generic “Materials” it takes to build an item, I would like to be able to lookup & copy the list of materials that are related to the “item” and create a new set of records that i can modify to the specific “project”.  


      How do I lookup and copy the MULTIPLE related records from the “Join-Item-Material” table to the “Join-Project-Material” table so I can modify the materials related to the specific project with out modifying the original Item.