Displaying primary key not text

[Daryl2106]

Hi,



I am a new Access user. The problem I am having is getting the data in a subform to display the text associated with the primary key rather than the primary key itself. In the subform StudentEnrolmentTable, faculty choose the CourseNumber from a combo box and the remianing associated fields are populated with and update querry. The problem is when the associated fields are viewed by faculy through the form, they are showing only primary keys and not the text the key is associated with.

Take care,

Daryl

[RuralGuy]

Are you using LookupFields? http://access.mvps.org/access/lookupfields.htm

[June7]

You should not be saving the associated fields data. Basic principle of relational database is to not duplicate data. If you want to display the information in the form then include the source table in the form's RecordSource by a query that joins the related tables. The jointype would be 'Show all records from StudentEnrolmentTable...' Then bind textboxes to the associated fields from the source table and set their properties as Locked Yes and TabStop No.

RuralGuy, that link isn't working for me.

[RuralGuy]

RuralGuy, that link isn't working for me.

Hmm...It works for me. They just changed their URL.

[June7]

Okay, now it works! Yes, I never set Lookups in tables. Drives me nuts when I have to work with db's that have. When I go to a table I want to see the real value.