timetabler
New member
- Local time
- Today, 07:13
- Joined
- Jan 22, 2013
- Messages
- 1
I'm just getting back into Access after a 8yr stint hiding away in Excel.
I'm using Access 2010 using a standard DB, (no SQL server).
I am trying to create a new record in the Previous School table based on an existing value of Student table.
Every student has an ID number, and every new student is given a student ID.
Every student also has a previous school (from the previous-school table).
I have made a simple form which displays this data.
The student data I have imported/pasted into the tabled link with a query and I can update these records, i.e. the query will return "School A" and I can change this to "School B".
However if I create a new student using my form, the previous school is empty, and read-only, (because there is no matching record in the previous school table), therefore I cannot type/select "School C".
What is the correct/preferred way of creating this record in the previous school table, so that I can populate the record?
The query "join" between student and previous school is "Include all records from student, and only those from "previous school" where joined fields are equal.
I'm using Access 2010 using a standard DB, (no SQL server).
I am trying to create a new record in the Previous School table based on an existing value of Student table.
Every student has an ID number, and every new student is given a student ID.
Every student also has a previous school (from the previous-school table).
I have made a simple form which displays this data.
The student data I have imported/pasted into the tabled link with a query and I can update these records, i.e. the query will return "School A" and I can change this to "School B".
However if I create a new student using my form, the previous school is empty, and read-only, (because there is no matching record in the previous school table), therefore I cannot type/select "School C".
What is the correct/preferred way of creating this record in the previous school table, so that I can populate the record?
The query "join" between student and previous school is "Include all records from student, and only those from "previous school" where joined fields are equal.