Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    28

    Unanswered: Can you help me understand lookup table?

    I have 2 tables in a one to many relationship - table 2 is a lookup table:

    Table 1:

    Fields:
    Barrier_id
    utm_zone
    northing
    easting
    barrier_type (record can only have one type of barrier)
    barrier_type_id

    Table 2:

    Fields:
    Barrier_type_id
    Description (this field lists 15 possible barriers)
    Acronym (acronyms for barriers)


    First of all, what exactly is a "lookup table"? What is its purpose?

    Could you give me an example of how it would or could be included in a queries. What is table 3's function? All it seems to do to me is merely list possible barrier types...why does it need to relate to table 1

    Thanks for your help

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    In it's simplest if you create a lookup field in table 1 on barrier_typeID, then table 2 will become a lookup table. The wizard will create the relationships and you are done.

    To manually create it, you would create a one to many relationship from table 2 barrier_typeID to table1 barrier_typeID. On your input form you could use the combobox wizard to lookup the values in a table, in your case table2.

    HTH

Posting Permissions

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