If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to create a table automatically after a data is inserted?
Dear all,
I have two tables, tbl_Student and tbl_DSSR. Each student needs to have their own DSSR table, which means, a student John may have a tbl_DSSR_John. Please show me some ways to do that. Thank you very, very much. This is such an impossible task. |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
|
#4
|
|||
|
|||
|
#5
|
|||
|
|||
"John Vinson" wrote in message ... On Sun, 30 Jan 2005 07:43:01 -0800, "Andre Bazin" Andre wrote: Dear all, I have two tables, tbl_Student and tbl_DSSR. Each student needs to have their own DSSR table, which means, a student John may have a tbl_DSSR_John. Please show me some ways to do that. Thank you very, very much. This is such an impossible task. It's a difficult task because it is AN EXTREMELY BAD IDEA. Storing data in tablenames is *NEVER* either necessary nor appropriate. Andre Bazin, John and Tim are right. Doing what you've asked will make maintaining and working with the database enormously harder, plus defeat most of the advantages and capabilities of the database product. Sincerely, Chris O. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Update Tables using forms | achett | Using Forms | 5 | January 28th, 2005 12:25 AM |
Automatically Delete Duplicated Data in Table | faxylady | Running & Setting Up Queries | 3 | September 29th, 2004 06:58 PM |
Autonumber | Ally H. | General Discussion | 7 | August 27th, 2004 04:51 PM |
Moving data from popup to subform | John Nurick | Database Design | 0 | May 6th, 2004 06:19 AM |
Automatically create charts from data table - help needed | Gordon | Charts and Charting | 1 | October 20th, 2003 05:49 PM |