Author |
Topic |
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 20 January 2003 : 14:27:58
|
Hi,
I have two tables in Access. One is called MYFILES and the other is called USERFILES. I am using Snitz 3.3.05 and these are parts of two MODs.
I use them both with an upload MOD. What I want to do is when uploading a file, I want the same information to go to both tables. Currently, I can only populate one table while uploading.
Please tell me what information you need from me, i.e. code, etc. to help me in understanding this.
Thanks so much,
Etymon
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 20 January 2003 : 14:32:40
|
Just write a second sql query (after the first query) to insert the data in the second table. |
Support Snitz Forums
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 20 January 2003 : 18:21:35
|
quote: Originally posted by Davio
Just write a second sql query (after the first query) to insert the data in the second table.
Thanks for the help, Davio!
Writing a query I don't know how to do though I have probably mimicked doing it already.
Let me try it and whether or not I get it done correctly, I'll write back.
Thanks again,
Etymon
|
Edited by - Etymon on 20 January 2003 18:26:02 |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 20 January 2003 : 22:41:47
|
It should be similar to the first query you are using to update one of the tables. If you need help with the query, post the query from your code and list the table fields in the second table you want to update. |
Support Snitz Forums
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 21 January 2003 : 14:58:32
|
I got sidetracked, will have more time late tonight.
Thanks for the offer, Davio!
Cheers,
Etymon
|
|
|
|
Topic |
|