Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / May 2005

Tip: Looking for answers? Try searching our database.

Database Relationships Question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jacob - 25 May 2005 16:48 GMT
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.
Kevin3NF - 25 May 2005 16:56 GMT
Please describe the business situation you are trying to solve...I don't
even understand your question....

Signature

Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions

> 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.
jacob - 25 May 2005 19:49 GMT
My database schema is found here

http://www.geocities.com/jacobpressures/NewDB.JPG

I wanted to connect Completed_Questions.QID with Answers.QID
both of which are foreign keys.
BruceM - 26 May 2005 14:31 GMT
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?

> My database schema is found here
>
> http://www.geocities.com/jacobpressures/NewDB.JPG
>
> I wanted to connect Completed_Questions.QID with Answers.QID
> both of which are foreign keys.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.