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

    Unanswered: Linking 2 databases - trouble defining relationship (access 97)

    This is my first time designing relational database....

    Ok, I have 2 completed databases - one a fish habitat database and the other a database containing data about flood structures.

    I need to join the 2 together - need one database. I know how to import tables - but am having trouble on defining the first relationship between the 2 database.

    The fish habitat database has a table (called "barrier type") which contains 3 fields (barrier id, description , acronym). The description field contains a record called "flood structures."

    Since my 2nd database contains information about flood structures (its main table is called "flood structures") - I would like to relate the "flood structures" record to the "flood structures" table from the 2nd database.

    I know you cannot link a record to a table - so I am stuck as how to link these two databases - help!

    If you need more info about my problem or the databases i am working with please let me know!

    Until then - thanks for your help


  2. #2
    Join Date
    Feb 2002
    In your fish database, find your floodstructure record, and choose lookup as its datatype. This will open the combo box wizard, and enable you to create a combobox of flood structures. As well a relationship will be created for you.

Posting Permissions

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