That's a little bit confusing, but may work... Do you see other possibilities here?

>Hi!
>
>Well, what is wrong with
>
>USE Jobs alias Jobs in 0
>
>AND
>
>USE JobsArch alias JobsArchs in 0
>
>in one mode, and
>
>
>USE JobsArch alias Jobs in 0
>
>AND
>
>USE Jobs alias JobsArchs in 0
>
>in second mode???
>
>In the Load event of the form you open a set of tables. Depenent on some public variable or setting, you open usual or "Arch" set of tables with corresponding aliases as a main tables ("Jobs" alias), and additinal tables into which you will copy records is opened as "Arch" set. You just switch between them. :-)
>
>When you switching to another set of tables from the form, just re-load the form...
>
>HTH.
>
>>>Move tables from DE into Load method code?
>>>
>>
>>Well, it would not solve the problem. All controls reference tables without "Arch". Since I will have to open another set anyway to perfrom my operation, I can not alias "Arch" tables without "Arch"
>>
>>See my problem? If we would use n-tier design, where data layer is separated from presentation layer, I would not have this problem...
>>
>>>>Hi everybody,
>>>>
>>>>I have Jobs, JobSteps, JobsHist, Delivery tables in JobControl database. I have JobsArch, JobStepsArch, JobsHistArch, DeliveryArch in the same database. I also have a form which uses first set of tables in its DE and all controls (grid, textboxes, etc.) are bound to these tables directly.
>>>>
>>>>I have to invoke this form in two modes - Archive (user selects jobs from jobs table and these jobs and related info are put into corresponding "arch" tables). I also need to perform the opposite operation - UnArchive - e.g. put "archived" jobs back into production (assign a new ID to avoid conflicts, though).
>>>>
>>>>So, my question is: how should I approach the second mode? The form I took from my colleague and just modified to fit my needs. How should I make this form to operate on the "arch" tables?
>>>>
>>>>Another idea would be to create a clone of the form and hack (or somehow) change all controlsources and DE. However, two forms are harder to maintain.
>>>>
>>>>I understand, that this is against n-tier design, but the form was designed using tables directly and bound controls...
>>>>
>>>>Would appreciate your ideas.
>>>>
>>>>Thanks in advance,