| Populating a combo box from a table [message #449045] |
Fri, 26 March 2010 06:57  |
rosswelsh
Messages: 42
Registered: February 2010
Location: Sunderland
|
Member |
|
|
Me again with another question! 
I want to populate a combo box using values from a table, I know you can manually enter values in the combo box's property palette using the 'Elements in List' option, but this combo box will have changing values and I would prefer it to come from a table rather than manual entry so that when users add a new staff name to the table it will automatically be in the combo box.
Im guessing I would need to use a trigger on this combo box, but which is the best to use and im guessing the SQL needed is more than just 'select * from staffname'?
Thanks very much.
|
|
|
|
|
|
| Re: Populating a combo box from a table [message #449048 is a reply to message #449045] |
Fri, 26 March 2010 07:18  |
rosswelsh
Messages: 42
Registered: February 2010
Location: Sunderland
|
Member |
|
|
|
The values will remain the same nearly all the time, except for when a new member of staff is added to the database (only about once a year or so), so I would require the list to check for any new values at runtime, and re-populate the list if necessary.
|
|
|
|
|
|
|
|
| Re: Populating a combo box from a table [message #449062 is a reply to message #449045] |
Fri, 26 March 2010 08:39 |
rosswelsh
Messages: 42
Registered: February 2010
Location: Sunderland
|
Member |
|
|
The user(s) will add the new staff member name(s) to the staffname table yes, through an Add New Staff Member form.
The names from the staffname table then need to be displayed in the combo box, so im not sure a list of values would work that way would it?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
