I am first time trying to use temporary table in my application and need support.
I have made a make table query which creates a table in front end containing record filtered by form's current record. Then, I use data definition query to generate a primary key in this table (This is a requirement that table should have a primary key). I could do up to this.
Now, I need to use one of the filed of this new table into my permanent table but I am not close to that.
I have some issues:
1. If I generate one new table from a current record of form and then navigate through other record and decide to again generate a table then this action deletes the old table. What is the best way to accomplish this task?
2. Does this temp table shall only be in back end?
3. How do I transfer data in permanent table?
The basis need is, I may need a temp table for couple of days/week alive, reason being I use this temp table data to send via email to be updated and untill update arrives, I should not delete the table?
Please give opinions to handle in the best way possible? Please excuse me if I am not clear enough.
I have made a make table query which creates a table in front end containing record filtered by form's current record. Then, I use data definition query to generate a primary key in this table (This is a requirement that table should have a primary key). I could do up to this.
Now, I need to use one of the filed of this new table into my permanent table but I am not close to that.
I have some issues:
1. If I generate one new table from a current record of form and then navigate through other record and decide to again generate a table then this action deletes the old table. What is the best way to accomplish this task?
2. Does this temp table shall only be in back end?
3. How do I transfer data in permanent table?
The basis need is, I may need a temp table for couple of days/week alive, reason being I use this temp table data to send via email to be updated and untill update arrives, I should not delete the table?
Please give opinions to handle in the best way possible? Please excuse me if I am not clear enough.