Hi,

I've got a small problem I can't find an answer to. I need to be able
to display multiple items in a combobox from a SQL generated field
(such as (SELECT     RTRIM(per_surname) + ', ' + RTRIM(per_first_name)
AS company_manager) and bind to the com_manager_per_id field (a FK to
per_first_name and per_last_name) in another table (company).

As I'll only have the first and last name of that person (not unique) I
need to store the per_id primary key against the company table so I can
do a look up later for the "company manager".

I can't find a way to do with using databindings although it seems like
it should be able to do what I want. Is this possible or will I have to
do this manually?

Any help would be great, and if I haven't been clear in what I'm asking
please tell me and I'll try and explain it in a different way.

Thanks,
Gus.