Discussion in 'OT Technology' started by jrmcm, Mar 13, 2003.
i know quite a bit, but that 5Gen_Prelude is the shizzle
I have a question, then...
I've got a table (of employees) that has last name and first name in two different colums. I've got a web form in which I want to be able to select an employee name from a drop down list that pulls from that employee table, but I want it to display both last name and first name. In the typical access form, that's not a problem because I can do that with a combo box, but you can't put combo boxes on web forms. So, any suggestions? I would assume that I could create a query or something of that nature to combine the values from the first name and last name colums into one field and then have the web form drop down list pull from that query. But, I'm not sure that would work, and even if it would, I wouldn't know how to do it (I know jack shit about Access). Any help is greatly appreciated.
well, the query is the easy part. Are you talking about the webforms inside Access? I'm not familiar with those. But the query would look something like the following:
Select FirstName & " " & LastName From Employees
You mean you can't put multi-column combo boxes in a web form right?
Then SLED's answer is fine. I mean normally you would index off of the EmployeeID (ie 2 columns, 1st is hidden with a 0" width, and the second as the Employee Name). That way the data returned is a number not a stored string which in most cases is better. Otherwise you end up having to reverse the query out (ie Which Employee ID has a first name of Joe and a last name of Smith - hoping like hell no one has spaces in their name).