Can I do a lookup on a lookup?
I have a database of client names. From that I have a lookup field on another form, with the ability to add new clients. I would like a third form with a lookup field from the lookup field of the second one so that I can populate the data from the other fields from the second form.
Is this possible?
Thanks
Nick