Combo/List Box Populating

[Stew]

I have several fields associated with each client ID for the names of dependents (dependent1, dependent2 and so on). They are stored in the same Table and of course, in the same record. I want to fill a list box with these values so the user can select one to fill out a form. When I attempt to set up a list box the values appear in the same row but in different columns. That is useless to me. I need them to appear in seperate rows for selection. Am I overlooking something obvious here? Can anyone offer a suggestion? Thanks

 

[chrismcbride]

If you are saying that you have a table with many dependants for the same client in the same record, then you have a design error. You should have a separate table with each dependant reocord stored separately and associated to the Client table with the Client ID. Once this is done you will have not trouble making the Combo box.
Chris