libraent
Posts: 11
|
| Posted: 04/18/2005, 3:08 PM |
|
I Found instructions for displaying 2 fields as one on a grid, what I want to do is display it on a record form.
Currently I have:
Control Source: VolunteerID
Data Source Type: Table/View
Data Source: Volunteers
Bound Column: VolunteerID
Text Column: VolunteerFirstName
Data Type: Integer
What I need is the first and last names to display as a drop down box. Can someone help me with this?
Thanks!
_________________
Thanks,
Shane Taylor
Libra Enterprises |
 |
 |
Nicole
Posts: 586
|
| Posted: 04/19/2005, 2:39 AM |
|
Hello,
It could be done via sql query. Use custom SQL as data source for your listbox. As you know you it should select Bound Column field and text Column field. You can use string functions specific for your database to concatenate two or more columns to be selected for Text Column. E.g. for MySQL query could be like
Select user_id, concat(first_name, ' ', last_name) as user_name from user_table
_________________
Regards,
Nicole |
|
|
|
libraent
Posts: 11
|
| Posted: 04/21/2005, 6:28 PM |
|
Thank you so much Nicole! This works:
Select concat(VolunteerFirstName, ' ', VolunteerLastName) as VolunteerID from Volunteers
_________________
Thanks,
Shane Taylor
Libra Enterprises |
|
|
|
|
