Relationships

[dsmaj]

This is probably a stupid question, but here goes anyway...

In my table relationships map, one of my tables whose primary key has a one to many relationship with multiple other tables, all of which enforce referential integrity, has what looks like a "1L" beside it instead of just a "1" like my other one-to-many relationships. Why is this?

Thanks,
Sam

 

[dsmaj]

I know someone must know what this is--cause I'm convinced it's a dumb question!

Anyone?
Sam.

 

[GrahamB]

Its not a couple of relationships overlapping?

Can you post a screenshot?

 

[dsmaj]

Its not a couple of relationships overlapping?

Can you post a screenshot?

That's a good idea...but I don't have anywhere to host it... is there a way to embed it into my post?

Sam.

 

[Rich]

You don't need to "host" it, post it here as an attachment

 

[dsmaj]

Ahhh...here goes..

Sorry bout the bitmap, I've only got MSPaint...

So what does that little "1L" mean beside InitiativeID? I've got other tables in the model that have the same properties, with a ID field linked a similar number of times but it just says "1" instead of "1L".... ???

Sam.

 

[Kodo]

looks like a one to one.

 

[GrahamB]

looks like a one to one.

Agreed

Try moving the tables one at a time to the other side so the table links into the left hand side. You should then see the "1" move to the other side and they won't be overlapping

 

[dsmaj]

looks like a one to one.

Can't be...I've double checked all the relationships--they're all one-to-many.

Sam...

 

[Pat Hartman]

It looks like multiple relationships pointing to the same field.

 

[dsmaj]

It looks like multiple relationships pointing to the same field.

Yeah, it is. All of them are 1-to-many though, and it USED to show up as just a "1", which makes sense. Now it shows up as a "1L" or something...and as far as I know, nothing has changed in the way the tables are related... Have you seen that "1L" before?

Sam.

 

[Pat Hartman]

It looks like 11 squished together.

 

[sjdibben]

Have you done a left join here or something?