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

    generate relationship upon matching text entered?



      generate relationship upon matching text entered?


      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