Relationship ?

[BC]

I used Analyze Table to guide me through splitt a table into two tables
and reduce some redundancy.
When I finished, I looked under 'Relationships" the relationship between
the two new tables did not show up ?
I'm new (obviously), would someone help explain this situation?

 

[John Vinson]

I used Analyze Table to guide me through splitt a table into two tables
and reduce some redundancy.
When I finished, I looked under 'Relationships" the relationship between
the two new tables did not show up ?
I'm new (obviously), would someone help explain this situation?

Well... set it up then!

Open the Relationships window. Add the two tables. Drag the Primary
Key field from the "one" side table to the Foreign Key field in the
"many" side table.

Splitting the tables just splits the tables - it doesn't magically
relate them.

 

[BC]

John,
The wizard apparently connected them is some fashion ???
When I open one of the tables I get a + sign on each of the records.
When I click on the + sign I see the data from the other table.
Sorry, if this is a dumb question, but I'm new at this and was trying
the wizards to see what it recommended for my tables.
I suppose I could connect them, but at this point, I'm not sure why?

 

[John Vinson]

John,
The wizard apparently connected them is some fashion ???
When I open one of the tables I get a + sign on each of the records.
When I click on the + sign I see the data from the other table.
Sorry, if this is a dumb question, but I'm new at this and was trying
the wizards to see what it recommended for my tables.
I suppose I could connect them, but at this point, I'm not sure why?

I haven't used that wizard much at all, so I'm not familiar with its
quirks! Try opening the relationships window and selecting one (the
"one" side I'd say) table and clicking the "Show Direct" button. It
may bring this concealed relationship into view.

If performance of your databases is of interest, I'd suggest opening
each table with subtables and using the Format menu option to turn the
subtables OFF. They can really make Access run sssslllloooowwww....

 

[BC]

John,
I'm not sure what you mean by the "one" side? There are no tables
showing up in the relationship window.
I was able to 'remove' the "subdatasheet" ... I suppose it created a
subdatasheet as opposed to a 'relationship' ???
my my my ... so much to learn ... so little time!

 

[John Vinson]

John,
I'm not sure what you mean by the "one" side? There are no tables
showing up in the relationship window.

Sorry! I meant to suggest that you use the Add Table icon to add the
wizard-created tables to the window. Then either their relationships
should become visible, or can be made visible using the "Show Direct"
or "Show All" buttons.

I was able to 'remove' the "subdatasheet" ... I suppose it created a
subdatasheet as opposed to a 'relationship' ???

The fact that it's showing a subdatasheet suggests (but may not prove)
that there is in fact a relationship. I'm guessing that there is but
as I said... no experience with this wizard so I'm not sure!

my my my ... so much to learn ... so little time!

:-{/ Yep. The learning curve is indeed steep and rocky, especially
when the Microsoft programmers go out of their way to conceal things
like newly created relationships!

 

[BC]

John,

"Show All" did it! ... the relationship was somehow hidden!

Thanks!
Bob