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