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
|
|||
|
|||
is data entered in one field supposed to appear in another field .
I have a simple question: I have two tables, a student table and an
assignment table. The tables have been related through a one-to-many relationship using the primary key called "student code". In addition, I have created a form to enter student data and one to enter assignment data. It seems to me that once I enter the student data, including the student code, into the student table, this information should also appear in the assignment table. Surely I do not have to enter the student code x number of times for every assignment that is given to the student. Is there some setting that I have overlooked that copies data to all related tables with the same field? Second, do I have to have data entered before I run a query? Any help would be greatly appreciated as I am completely frustrated. |
#2
|
|||
|
|||
is data entered in one field supposed to appear in another field .
db struggle wrote:
I have a simple question: I have two tables, a student table and an assignment table. The tables have been related through a one-to-many relationship using the primary key called "student code". In addition, I have created a form to enter student data and one to enter assignment data. It seems to me that once I enter the student data, including the student code, into the student table, this information should also appear in the assignment table. Surely I do not have to enter the student code x number of times for every assignment that is given to the student. You are mistaken and you would in fact have to re-enter the student code in each assignment record UNLESS you set up the forms such that the assignments form is an embedded subform within the student form. Then entering the name of the student code field into the MasterLink and ChildLink properties of the subform control would cause two behaviors. 1) The records shown in the assignment subform would automatically be filtered to only show assignments for the student currently displayed in the main form. 2) New records created in the assignment subform will automatically inherit the student code value from the main form record. Second, do I have to have data entered before I run a query? You could create a query using the two tables before entering any data, but of course the output of the query would also be empty so it would be difficult to determine if the structure of the query was correct. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Memo Field | Sam | General Discussion | 12 | November 10th, 2005 09:16 PM |
How do I save an access document in word document? | cmartin | General Discussion | 2 | September 13th, 2005 11:26 PM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
SQL view of messed up action queries | Kendra | Running & Setting Up Queries | 2 | August 31st, 2004 09:53 PM |
Blank field until data is entered | Todd | Using Forms | 1 | July 29th, 2004 06:34 PM |