>William,
>
> Thanks just what I was looking for..unfotunatly I would love to just put it in VFP and be done with it but I have to clean it up then export for use as an access 2.0 db(god its ugly) I would fight harder against this but I just started and the decision was already made. Thank you
>
>
>There is a fine line between genius and madness, my manager is that line

seems like you have a good candidate for a three tier application, anyway having access on the front end could be very unreliable situation.