2 Replies Latest reply on May 3, 2010 4:32 PM by x94bp6ru6

    generate relationship upon matching text entered?

    x94bp6ru6

      Title

      generate relationship upon matching text entered?

      Post

      Say for example I have two tables in each are

       

      Table one (product details)

       

      serailNO    productName   productIntro   productCode  etc..... other details

       

       

      Table two (for shipment)

       

      serailNO    productName   productIntro   productCode  etc.....  contacts and so on

       

       

      right now, I'm using the easiest method which simply create relationship between tables using serail number,  and product names and codes are set to "look up" from table one.

      But i'm wondering is there a way I can have =>  Entering in either field, and the other fileds automatically look up corresponding data from table one  ?  'cause sometime you just can't remember ID for every product thus I have to find it.

       

      thank you for advance