Display only part of table in combo box

[frederick]

I have a table of friendly names where each person may not have any or may
have several. They are in a table with ID and name, such as:
1 Cat
1 Cathy
4 Fred
5 Ed
5 Eddie

How can I get the combo box to only display Cat and Cathy for person # 1 and
Fred for person # 4?

Fred

 

[KARL DEWEY]

You could add another field to flag the ones to display.

 

[frederick]

I got part of it to work with a query that matches up the people.id with the
[friendly name].id. It works for the first record, but then it doesn't
change with the different records. For instance, people.id 5 still shows Cat
and Cathy. How can I get it to show the proper friendly names for specific
people.ids?

Also, how can I get it to put the first friendly name into the combo box? I
get Cat and Cathy if I click the arrow, but the edit box part is blank.