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
Combo/List Box Populating
- Thread starter Stew
- Start date
Fornatian
Dim Person
- Local time
- Today, 17:25
- Joined
- Sep 1, 2000
- Messages
- 1,396
What you are overlooking from the info you have given is that you should have a table called dependents, so that rather than having a maximum number of dependents as you have at the moment using fields numbered dep1,dep2,dep3 etc.
The structure you should have(from the limited info) is one table with clients and one table with dependents.
Forming a one-to-many relationship between these two tables will allow you to have as many dependents as you like.
AND it will allow you to select a dependent from a list box(in answer to your original question!)
Unfortunately, making these changes can mean a huge design modifications.
Good luck.
Ian
The structure you should have(from the limited info) is one table with clients and one table with dependents.
Forming a one-to-many relationship between these two tables will allow you to have as many dependents as you like.
AND it will allow you to select a dependent from a list box(in answer to your original question!)
Unfortunately, making these changes can mean a huge design modifications.
Good luck.
Ian
Similar threads
