Foreign Key shows Primary Key 'Name' .. not number... huh?

[ron G]

I have an application of Membership.

The tables are:

Members

Meetings

Visitors etcc...

I have a TOC GROUP that consists of: (see pic)

Members TOC

Member Meeting Join

Meetings

First, EVERYTHING WORKS.

I just don't understand 'why'??

I have a report based on MEMBERMEETINGJOIN.

In this report I have a subsummary based on MemberMeetingJoin::KF_Member

Item #1: The Members TOC KP_MemberID is a SERIAL field with autoupdate.

Item #2: MemberMeetingJoin::KF_Member is a plain, text field that when placed in the report sub summary SHOWS THE CORRECT FULL NAME; ie, John Jones? Huh? Shouldn't the KF show the KP???

It's late so am out of here... Thanks for your thoughts.

Ron

[ron G]

About 1 AM last night I think I 'got it'.

The input form for Members and Meetings has a Value List that 'shows' the Member Name.

Somehow, when I specify the KF_MemberID, it goes and picks up the MemberName.

Or, does it just 'look' like I am picking up the MemberName and in reality I am picking up the

KF_Member ID?

[dansmith65]

It sounds like the field is displayed as a popup menu, and the value list is set to return the ID, but only display the name. Have a look at the value list specified to see what I mean. Also, make a copy of the field and change from popup menu to edit box; you'll see that it shows you the actual value of the field.

[ron G]

ahhhh. Thanks for 'turning on the light'