Hi Robbie!

>What I'd like to achieve is to be able to have a lookup table available from which two or more fields show, during the lookup
>action, and from which two or more fields of data from one record in that table can be inserted into the table which I'm
>inserting into and/or updating.

Firebird in itself has no support for lookups. Typically this is something provided by a client program that you write, but answering your question without knowing your programming language and component set would only be guesswork (we don't even know your Firebird or InterBase version). Moreover, this question is more likely to belong to another list than Firebird-support, e.g. if I wondered about this in my programming environment (Delphi with IBO), I would typically send this question to the ibobjects support list (or rather, I'd check the Tech Info sheets at www.ibobjects.com so I didn't have to ask).

Set