2003 split database

B

Bonnie

A general question:

I split my database and now do not see the related table when I pull up a
table, i.e., there are no little plus symbols to pull down. I saw them
before I split it and I see them in a split table I did in 2002. Can anyone
tell me why please?

Thanks,
 
L

Larry Linson

A general question:

I split my database and now do not
see the related table when I pull up a
table, i.e., there are no little plus
symbols to pull down. I saw them
before I split it and I see them in a
split table I did in 2002. Can anyone
tell me why please?
Click to expand...

Are you talking about the related Table for Lookup Fields? If so, most
developers do not use them, and regard them as a handy tool for end users,
but one that generally causes more problems than it solves -- based on the
number of newsgroup questions they generate.

Did you specify the Relationships in the back-end? In the front-end?

I guess the best advice I can offer is take a look at the 2002 database
where you can see them and try to determine what you did differently in this
one, if anything.

Larry Linson
Microsoft Access MVP
 
B

Bonnie

Hi Larry, thank you for responding. I am not talking about Lookup fields
(though I do use them and haven't had any problems). I am just talking about
browsing regular tables. I set up the relationships in the backend - should
it have been the front end? So is there nothing different about the way 2003
handles this from the past versions?

Thanks in advance.
 
L

Larry Linson

I am not talking about Lookup fields
(though I do use them and haven't had
any problems).
Click to expand...

Lookup fields obscure what is really stored, because when you see them
displayed, what is really displayed is a value from another, related table.
Many novice users are tripped-up when their query returns a number instead
of the name that they are used to seeing. And, even some not-so-novice users
can forget and be equally tripped-up.
I am just talking about
browsing regular tables. I set up the
relationships in the backend - should
it have been the front end?
Click to expand...

Relationships should be defined in the same database where the actual table
resides -- the back-end. So you have them in the proper place.
. . . So is there
nothing different about the way 2003
handles this from the past versions?
Click to expand...

There's not _supposed to be_, as far as I know. It appears that there _is_.

I split my database and now do not see
the related table when I pull up a
table, i.e., there are no little plus symbols
to pull down. I saw them before I split it
and I see them in a split table I did in 2002.
Can anyone tell me why please?
Click to expand...

The little plus signs that open up a view of a related table is called
"Subdatasheet view". Check Access 2002 Help, if you still have it
installed.... under index, type "subdatasheet", click it, and look at "About
subdatasheets".

I can duplicate the problem you report -- no little plus signs alongside
the foreign key field when the tables are linked in Access 2003, little plus
signs to show the related table values when the tables are not linked in
Access 2003, and little plus signs to show the related table values in
Access 2002, whether the tables are in the same DB or linked.

My guess is that the problem is in the viewing code, not the tables
themselves, because I created a table and a related table in Access 2003,
and viewed those in both Access 2002 and 2003.

I don't do much work directly in Table View, so hadn't noticed it. I'll
report it to the proper people, but couldn't predict what kind of priority
it might receive.

Larry Linson
Microsoft Access MVP
 
B

Bonnie

Well at least I'll stop trying to figure out what when wrong. Thanks for
checking it out and hopefully the next upgrade will correct it.
 
Top