Editing junction table as subform via Form
I have following tables:
Course table:
CourseID(primary key) + (first field in combo box)
CourseName(second field in combo box)
CourseDescription
Students table(source for Main form):
StudentID (primary key)
StudentName
StudentPhone
StudentEmail
Enrollments table(junction table and source for subForm)
CourseID (foreign key referencing the Courses table) + made into combo box that stores selected value into CourseID
StudentID (foreign key referencing the Students table)
Both fields in Enrollments table are primary keys
I hope that the fact everything is in polish will not bother you.
I would like to assign Student selected in Main form to X amount of courses via SubForm but it won't let me edit IdKlient(IdCourses). Error states: can't edit this control, it's related with auto increment field "IdKlient"(IdCourses)
Solution
After playing around I found that unchecking "cascade delete Related Records" in relationships between Courses and Students to Enrollments table fixed the issue and gave me disired effect.
- Moving Files in MSOffice Access 2010
- How to format a general date to a distinct month in a combobox dropdown list in Access VBA?
- Date/Time Format VBA Access Query
- Use SQL to combine multiple Crosstab query results into individual Bins (ranges)
- Referring to a subform as recommended produces an error
- Building <select> in Access form
- Method 'columns' of object '_Global' failed error - VBA Access
- how can i extract the form information from a .mdb file?
- Dlookup syntax with multiple criteria including "Like"
- MSCAL.OCX not working on MS Access 2010(64-bit) on Windows 10(64-bit)
- MS Access Listbox click will not register a listbox selection
- Access VBA: How do I make the VBA editor stop auto-filling values?
- VBA Replace “Start” attribute deletes text
- Search by specific date in Access database with VB.net
- Sum Time Field in Access
- What are the Pros and Cons of VBA Code vs Macros in MS Access?
- How to reduce ms access database file size(*.accdb) after deleting data in it (MS Office 2007)
- How do I open an old Microsoft Access adp file with invalid connection strings?
- I need to split a text column in Access that stores dates in MM/YYYY and MM/DD/YYYY format to remove the day format
- Query to Find Adjacent Records in Access 2016
- Access VBA create a new table in an email when the field changes
- Microsoft office Access `LIKE` VS `RegEx`
- What is wrong with the variable?
- Error in odbcConnectAccess2007("BD-Embalses.mdb"). R could not find the function "odbcConnectAccess2007" after installing and loading RODBC
- SQL Learner -- MS Access 2013 ON UPDATE CASCADE and ON DELETE CASCADE
- Why does Access-Vba stops even if AllowSpecialKeys is turned off?
- How to disable access security notice "A Potential security concern has been identified"
- How to speed up the tranfer of information between Excel and Access?
- Access VBA MSHTML document with scripts loads slowly
- Populating subform fields from main form field