temp directory

[dadesiboy]

I have 4 tables that I need to keep adding infromation to, I have converted the tables into forms, however the only problem with this that I face is that as soon as I type in somethign it automatically becomes updated in the table. Basically i need to know if there is a way in which i can update everytihg in a temp directory first and then have it all be placed into the main table after I have finished. Thanks

 

[AlaskanDad]

Sure, I've done that. The trick is to create a parallel table (TempTable) to the one you eventually want to dump everything into (PermanentTable). Do all of your data work in the TempTable. Once you are ready to add it to your PermanentTable, run an Append Query from TempTable to PermanentTable. Lastly, run a Delete Query to dump the contents of TempTable.

 

[dadesiboy]

So do I make a whole new table and link the two togather? How do I go about making a temptable and permtable? I am a confused databaser here. Thanks

 

[AlaskanDad]

Let's say that your main table is called EmployeeTbl. You want to work on some information temporarily and then have it added to that table. In the tables section, hold down the Ctrl key and drag the EmployeeTbl (PermanentTable in my previous example) to a blank space in the section. This makes a copy called Copy of EmployeeTbl. Rename it TempEmployeeTable (My TempTable) for clarity's sake. Both of these tables now have the exact same properties. You don't have to link them in any way. Just run the Append and Delete queries as I described.

Think of them as two buckets. You want to play with the data in the Temp bucket without disturbing the Permanent bucket. Once you're done playing, you dump the contents of the Temp bucket into the Permanent one (Append) then empty out the Temp bucket (Delete).