Results 1 to 3 of 3

Thread: Autolookup

  1. #1
    Join Date
    Feb 2004
    Location
    China
    Posts
    4

    Unanswered: Autolookup

    Hi,

    I have a table which contains 2 fields e.g A & B with 1 to 1 relatioship. I would like to create another table where when I enter field A, field B will be automated be updated. I beleive it can be done by auolokup by just do not know how to start.

    Thanks

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    in principle you should not want to do this: "B" is known once "A" is defined so you should not duplicate "B" in your new table.

    a query will find "B" for you any time you need it.

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Feb 2004
    Location
    China
    Posts
    4
    The 1st table was the relationship of A & B.In fact, it is updated from query. The second table is a table to enter data.Which means each time I enter a data in A, it will show the B in the other field.

    Do you have any example file on this ?

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •