In addition to what Hilmar told you, use Views.
>Hi
>
>I'm trying to define the best aproach on a LAN based aplication...
>My question is:
>should a I open my tables and never close then (to speed up data operations) or in the other end, should I open tables just when I need them, since as I understand, Foxpro tables are fragile and could get damaged in a LAN failure.
>
>I know I should use SQL Server as the best way of doing this, but I'm no expert and dont have that much time to get the proper training and do a SQL Server application.
>
>(any sugestions, samples and so on would be great)
>
>TIA
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer