G
Guest
I have used Allen's sort code in my application and it works great...except
for one thing I can't figure out how to deal with.
Alot of my table fields are look-ups o other tables. For instance TableA has
EmployeeID, which has a relationship with TableEmployees, where the person's
actual first and last names are held. TableA only stores the EmployeeID.
In my form, if I use Allen's code, it sorts on the EmployeeID, not the
user's name. I've tried all sorts of work-arounds, like trying to tell it to
look at the field's column numer with the name, but it doesn't like that.
Suggestions?
for one thing I can't figure out how to deal with.
Alot of my table fields are look-ups o other tables. For instance TableA has
EmployeeID, which has a relationship with TableEmployees, where the person's
actual first and last names are held. TableA only stores the EmployeeID.
In my form, if I use Allen's code, it sorts on the EmployeeID, not the
user's name. I've tried all sorts of work-arounds, like trying to tell it to
look at the field's column numer with the name, but it doesn't like that.
Suggestions?