referencing to same table

[carelfly]

i need to setup a form to entering new clients into our database - the problem is we need each client to be "referred" to us by another client (this is important info) but if i try use a lookup to find the client i can't do it coz they're on the same table - any ideas. I also need to make a report that'll show me who referred the four before:
client v referred by client w referred by client x referred by client y referred by client z

 

[namliam]

This is quite doable and is refered to as a "SELF JOIN"
Select..
From customer C1
Join Customer C2 on C1.id = C2.RefererID
etc...

You can also quite easily direct a combobox to your same table. Should not be that hard to do.