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
|
|||
|
|||
One form(as a template) to many tables with same fields
i have to build a form which is built purposely for data entry. So i need the
form(masterpiece) to become a template for other tables which have the same fields. For eg: i got tblWEEK01,tblWEEK02,tblWEEK03 all with the same fields. In week01 i will enter data into tblWEEK01 using FORM(masterpiece) and in week02 i will do the same thing to enter data into tblWEEK02 with the same FORM(masterpiece) So in other words, the FORM that i created become the template for all the similar table, can i know how can i do it? i only manage to enter data into tblWEEK01 Urgent, thanks for the help... |
#2
|
|||
|
|||
Almost certainly, from your description, your database is unnormalized and
violates good relational database design practices -- immediately visible by the fact that the table (names) themselves are part of the data. I'd suggest you reconsider that table design, and replace all the separate tables with a single one, with a data field that identifies the week. In the long run, it will save you mental trauma and grief. That said, if each of the tables has the same fields, you can set the RecordSource of the Form in its Open event, or use the Filter argument of the DoCmd.OpenForm statement to override it. That RecordSource will determine where the form gets its data. Larry Linson Microsoft Access MVP "1 form for similar table" 1 form for similar wrote in message ... i have to build a form which is built purposely for data entry. So i need the form(masterpiece) to become a template for other tables which have the same fields. For eg: i got tblWEEK01,tblWEEK02,tblWEEK03 all with the same fields. In week01 i will enter data into tblWEEK01 using FORM(masterpiece) and in week02 i will do the same thing to enter data into tblWEEK02 with the same FORM(masterpiece) So in other words, the FORM that i created become the template for all the similar table, can i know how can i do it? i only manage to enter data into tblWEEK01 Urgent, thanks for the help... |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
My tables lost their AutoNumber fields | Bill Nicholson | Database Design | 2 | July 2nd, 2004 02:20 AM |
Mutliple Tables lookup? | Westley | Database Design | 4 | June 15th, 2004 01:07 AM |
do i need six tables, or one? | steve matco | Running & Setting Up Queries | 3 | June 9th, 2004 04:48 PM |