Hi guys!
That's pretty heads-up, Patrick, making all bound data views and a good way to simplify your migration in the long-term. The only problems I have heard about are blank dates and memo fields. Blank dates cause a problem because ODBC can't seem to deal with them too well (they come across with a 19thC date) and memos come across REALLY slow compared to other data. Other than that, Marks comments make a lot of sense for you.
>>If i bind my controls to db fields and later on want to migrate to sql server ( as a back end ) will i run into trouble or will it work.
>>I only use views....
>
>Usually, no problem. You need to bind controls to fields even for remote data. In view designer, just identify the key field(s) and which are updatable fields, then check the Send SQL Updates box.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05