Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2011
    Posts
    1

    Red face Unanswered: Is it possible to search multiple databases by their primary key?

    Hello,

    We have an Access Database for each facility where I work and they all have the same type of primary key...a material part number. We have the database in form view so someone will open it up and we have a "search part number" button which will pop up a box where they can type in the part number. The database will then take them to the record which contains that part number and includes other information they require to do their job. We made the part number the primary key because we do not want the same part number appearing on more than one record.

    The issue we are facing now is that people who need to get information for a part number, need to go into each facility's database and search sometimes because it may not be in the facility database they think it is in. All of the facility databases look almost identical with the primary key in all of them being "part number".

    I was wondering if there is a way to somehow link the primary keys for all of the facilities (~5 in total) together so that someone could instead click on an initial database, search for part number, and it will tell them which one of the facility databases it is in and / or take them there...
    Since the primary key in each individual database disallows someone from entering in the same part number on different records (which we want), we would also like to have it disallow someone from entering in a part number if it is found in ANY of the facility's databases.

    The table which holds the primary key (part number) for each database is titled the same thing...not sure if that is going to pose a problem.

    Please let me know if you need more information. It is slightly difficult to explain clearly.

    Any help you can give would be greatly, greatly appreciated.

    Thanks!

    Mandy

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You could create linked tables pointing to the actual tables in the different databases, then use a UNION query uniting these tables and perform the search on it.
    Have a nice day!

Tags for this Thread

Posting Permissions

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