>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,