Database Relationships Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to connect two foreign keys? if so, is this desirable? Why not?

This is a strange question for me. But Access is so limited i've run out of
options.
 
Please do not start by asking people to navigate to another site in order to
help you. You need to describe your database's function, briefly describe
the tables, and identify key fields. You don't need to list all of the
fields in every table, only the relevant ones. "Employee personal
information" is all that is needed to describe an employee table, unless
particular fields are part of your question. As for your question, a foreign
key exists because of its relationship to a primary key. Without that
relationship it is just a field. Are the foreign keys in question both
related to the same table, or to different tables? What do you hope to gain
by relating them to each other?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Enforcing referential integrity across databases 5
Relationships 1
Establish relationship between tables using TWO fields 8
Look up tables vs. relationships design 1
Database 3
Access Newbie trying to create Access Database for survey data 0
Database for document tracking 0
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5

Back
Top