If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Indeterminate relationship
What would cause a relationship to be "Indeterminate" in Access XP? I've got
two tables, and I'm trying to set up a simple One-to-Many relationship. I've done it a hundred times. This time, the program insists that it can't determine what kind of relationship there should be. The tables are as follows: tblNames NamesID - autonumber PK Name - Text .... tblCallOutDetail CallID - autonumber PK ShiftID - Long Integer NamesID - Long Integer FK I'm trying to join the two NamesID fields, but it keeps returning an "Indeterminate" relationship, and has greyed out all the options in the Relationship box. Any help would be really appreciated... |
#2
|
|||
|
|||
Indeterminate relationship
Are you sure that the primary keys are set as you said in your post?
Are the tables both in the same database? -- Bridge Players know all the Tricks "Dennis Snelgrove" wrote: What would cause a relationship to be "Indeterminate" in Access XP? I've got two tables, and I'm trying to set up a simple One-to-Many relationship. I've done it a hundred times. This time, the program insists that it can't determine what kind of relationship there should be. The tables are as follows: tblNames NamesID - autonumber PK Name - Text .... tblCallOutDetail CallID - autonumber PK ShiftID - Long Integer NamesID - Long Integer FK I'm trying to join the two NamesID fields, but it keeps returning an "Indeterminate" relationship, and has greyed out all the options in the Relationship box. Any help would be really appreciated... |
#3
|
|||
|
|||
Indeterminate relationship
Yes. I checked again just now and the Primary keys are as I said. The
tblNames table is in another file and is joined through a link. The tblCallOutDetails is a local table. "Pat hartman" wrote in message ... Are you sure that the primary keys are set as you said in your post? Are the tables both in the same database? -- Bridge Players know all the Tricks "Dennis Snelgrove" wrote: What would cause a relationship to be "Indeterminate" in Access XP? I've got two tables, and I'm trying to set up a simple One-to-Many relationship. I've done it a hundred times. This time, the program insists that it can't determine what kind of relationship there should be. The tables are as follows: tblNames NamesID - autonumber PK Name - Text .... tblCallOutDetail CallID - autonumber PK ShiftID - Long Integer NamesID - Long Integer FK I'm trying to join the two NamesID fields, but it keeps returning an "Indeterminate" relationship, and has greyed out all the options in the Relationship box. Any help would be really appreciated... |
#4
|
|||
|
|||
Indeterminate relationship
Sorry, but the only way that I can get the relationship type to say indeterminate is if the one-side tabletable does not have a primary key.
-- Bridge Players know all the Tricks "Dennis Snelgrove" wrote: Yes. I checked again just now and the Primary keys are as I said. The tblNames table is in another file and is joined through a link. The tblCallOutDetails is a local table. "Pat hartman" wrote in message ... Are you sure that the primary keys are set as you said in your post? Are the tables both in the same database? -- Bridge Players know all the Tricks "Dennis Snelgrove" wrote: What would cause a relationship to be "Indeterminate" in Access XP? I've got two tables, and I'm trying to set up a simple One-to-Many relationship. I've done it a hundred times. This time, the program insists that it can't determine what kind of relationship there should be. The tables are as follows: tblNames NamesID - autonumber PK Name - Text .... tblCallOutDetail CallID - autonumber PK ShiftID - Long Integer NamesID - Long Integer FK I'm trying to join the two NamesID fields, but it keeps returning an "Indeterminate" relationship, and has greyed out all the options in the Relationship box. Any help would be really appreciated... |
#5
|
|||
|
|||
Indeterminate relationship
On Wed, 28 Jul 2004 18:02:20 -0400, "Dennis Snelgrove"
wrote: Yes. I checked again just now and the Primary keys are as I said. The tblNames table is in another file and is joined through a link. The tblCallOutDetails is a local table. You cannot create a relationship with relational integrity enforced unless both tables are in the same database. The reason? If you put a referential constraint in A.MDB on a table in B.MDB, there is nothing to prevent someone from opening B.MDB directly (or from X.MDB) and entering data which would violate the constraint. You simply cannot do what you ask. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
#6
|
|||
|
|||
Indeterminate relationship
Ah. That's understandable, but does this mean that I can't make this a 1:M
relationship? Visually, the program looks like it's creating a 1:1 in the relationship window. Or does it just look that way because it can't create any referential integrity? I'm just interested in the 1:M relationship; not enforcing integrity. My form will be ensuring integrity by using dropdown boxes with the"Limit to list" turned on. "John Vinson" wrote in message ... On Wed, 28 Jul 2004 18:02:20 -0400, "Dennis Snelgrove" wrote: Yes. I checked again just now and the Primary keys are as I said. The tblNames table is in another file and is joined through a link. The tblCallOutDetails is a local table. You cannot create a relationship with relational integrity enforced unless both tables are in the same database. The reason? If you put a referential constraint in A.MDB on a table in B.MDB, there is nothing to prevent someone from opening B.MDB directly (or from X.MDB) and entering data which would violate the constraint. You simply cannot do what you ask. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
#7
|
|||
|
|||
Indeterminate relationship
On Thu, 29 Jul 2004 09:08:06 -0400, "Dennis Snelgrove"
wrote: Ah. That's understandable, but does this mean that I can't make this a 1:M relationship? Visually, the program looks like it's creating a 1:1 in the relationship window. Or does it just look that way because it can't create any referential integrity? I'm just interested in the 1:M relationship; not enforcing integrity. My form will be ensuring integrity by using dropdown boxes with the"Limit to list" turned on. There are several graphics for joins. A join that does not have RI enforced will just have a dot at each end; a one to one will have a numeral 1 at each end; a typical RI enforced one to many will have an arrowhead on the many side. You won't be able to check RI in the relationships window, but you should be able to create a relationship which will be the default join whenever you include the two tables in a query. If the "one" side table is in the database where you're editing the relationship, and you use the field with a unique index in the join, it should show 1:n rather than indeterminate - but I'll confess I haven't actually tried this exact situation! John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Relationship Diagram | lt | Setting Up & Running Reports | 0 | July 8th, 2004 01:58 PM |
Access 2000 Relationship window | lmontey | General Discussion | 1 | June 16th, 2004 04:17 AM |
Database -relationship set up | Harry Bo | Database Design | 3 | June 15th, 2004 12:06 AM |
Setting dual relationship with tool connector | Carlos | Visio | 0 | May 20th, 2004 12:51 AM |