1) Change the form control from text to combo
2) Have the program query for the existence of a couple of new tables:
Referred, and SalesPerson.
3) If they exist, populate the lists with their contents (these would be
one field tables)
4) If they don't, don't populate the lists.
5) Done.
Please?  If you have trouble with this method, feel free to contact me for
further instruction  ;)
------------------------------------------------------------------------
Marc Elbirt                                          Computer Pages Inc.
Systems Administrator                             253 Sheppard Ave. West
marc@cpol.com                                    Toronto, Canada M2N 1N2
WWW - http://www.cpol.com      Ph: +1 416 225 3030  Fax: +1 416 225 6737