Cannot See a Child Table Field

[Guest]

Hi:

I'm designing the typical Many to Many Student-Classes application. The
junction table is called tblLink and the two key fields are ClassID and
StudentID.

In the design where tblClasses is the parent table, I elected to hide
ClassID in the child table. However, in the design where tblStudents is the
parent table, I want to see the ClassID field in the child table, however, it
is NOT visible. Is this related to the fact that I hit ClassID in other form?
How can I correct this? And will displaying ClassID have any impact on the
other form where I want to hide ClassID?

Thanks,
Robert

Note: I'm using the same form for both designs. It is called sfrmqryTblLink.

 

[John Vinson]

Hi:

I'm designing the typical Many to Many Student-Classes application. The
junction table is called tblLink and the two key fields are ClassID and
StudentID.

In the design where tblClasses is the parent table, I elected to hide
ClassID in the child table. However, in the design where tblStudents is the
parent table, I want to see the ClassID field in the child table, however, it
is NOT visible. Is this related to the fact that I hit ClassID in other form?
How can I correct this? And will displaying ClassID have any impact on the
other form where I want to hide ClassID?

Thanks,
Robert

Note: I'm using the same form for both designs. It is called sfrmqryTblLink.

If the ClassID field is concealed in sbfrmqryTblLink, then of course
it will remain concealed anytime you use that Form - whether it's a
subform of the Classes form or of the Student form. Why should it
suddenly become visible, just because the context is different??

Note that as a rule you may not want to display the ID at all
(certainly not if it's an Autonumber ID).

John W. Vinson[MVP]

 

[Guest]

Hello John:

Both ClassID and StudentID are TEXT fields, I don't use Autonumbers.

After I posted the question, I realized the solution was in fact using two
different forms as the subforms, one with tblClasses as the parent, and the
other with tblStudents as the parent. Everything is properly displayed.

Having said that, I still don't know how to change my mind if I
inadvertently hide the wrong child field and want to display that field in
the subform. I tried the Visible Property but that didn't seem to do anything.

Thanks,
Robert

 

[John Vinson]

Hello John:

Both ClassID and StudentID are TEXT fields, I don't use Autonumbers.

After I posted the question, I realized the solution was in fact using two
different forms as the subforms, one with tblClasses as the parent, and the
other with tblStudents as the parent. Everything is properly displayed.

Having said that, I still don't know how to change my mind if I
inadvertently hide the wrong child field and want to display that field in
the subform. I tried the Visible Property but that didn't seem to do anything.

I guess I don't understand. If the Subform doesn't have a control
bound to the ClassID field, then a) it won't display the ClassID and
b) you can add a control. If there is a control with its Visible
property set to No, then you can change that property.

Why isn't the field displayed?

John W. Vinson[MVP]

 

[Guest]

Hi John:

When the form was displayed, I highlighted a column in the child table
[datasheet view], right-clicked, selected "Hide Column". If I make a mistake
and do that to the wrong column, I would like to know how to show the column.

Hope the above explains my problem.

Thanks,
Robert

 

[John Vinson]

Hi John:

When the form was displayed, I highlighted a column in the child table
[datasheet view], right-clicked, selected "Hide Column". If I make a mistake
and do that to the wrong column, I would like to know how to show the column.

Hope the above explains my problem.

Thank you. It does, and was not obvious from previous discussion! I
never use datasheets so I didn't think of that possibility.

Format... Unhide Columns on the menu should do it for you.

John W. Vinson[MVP]

 

[Guest]

Thanks so much John, that sounds as if it's exactly what I was looking for.
Have a great day.

Robert

:

Format... Unhide Columns on the menu should do it for you.