>Ko,
>
> Every solution have is benefics and is problems.
> I allready program as you do (opening the tables is startup), now i open the tables as i need (but avoithing to open many tables for each form), must of the tables work behing, and if the is need data for several tables, why not create a view ???
> Another reason because i do not like opening all tables at the begin, it is some off then, have little use, or they are used only in a especif part of the program and the user doesn´t have access to that part, and if i open ALL tables at beging the security maybe or maybe not compromised.

---

I'm sorry if i told you that i open all the tables at application startup.
I thought i said that i only opened the base tables. With that i mean only the tables that are used in many of my forms. Specific tables i still open in the form itself, and not at application startup

---

>Question:
> If in one form, the user is "creating" a client and in another is making a sale to another client, how does it stay ?

---

That's a thing to look at.
When the user made changes or as you say creates a new record, you have to make sure that the changes are saved before the record pointer moves.
you can handle that by asking to save the data when they leave the form.