Value List containing 2 fields

[jimlongo]

I'm sure this should be easy . . . he said,

I have a table CLIENTS, each record has room for up to 2 people to be named.

They start as LastName1, FirstName1, LastName2, FirstName2

Then there's a calculation for FullName1 and FullName2

Now in the SESSIONS table I want to be able to choose clients with a drop-down list

So I want to have a Value List with both those names in it.

I can't see how to do that in the Value List interface.

I've created a field in SESSIONS that does a Lookup of the value in CLIENTS::FullName1(FullNameA) , and also CLIENTS::FullName2 (FullNameB)

How can I put FullNameA and FullNameB in the Value List?

Thanks,

jim

[bcooney]

Jim,

Each client record should contain only one set of fields for name (Name_First, Name_Last and if you want calc fields for NameFull_c, Name_LF, etc.). If you need more than one person assoc with a client, then you need a new table related to Clients by ClientID, "Contacts."

Barbara

[jimlongo]

I had a feeling you were gonna say that.

Thanks.

[bcooney]

Anytime you find yourself creating fields with a _1, _2 suffix, think, "is this better in a child table?"

I know novices tend to think that they are over-complicating their system when they have many tables, but actually you're making future reporting possible.

[comment]

Anytime you find yourself creating fields with a _1, _2 suffix, think, "is this better in a child table?"

I agree, of course - but the answer is not always "yes".

MultiValuesVL.zip