Creation of records in related table
I have two tables A and B. Table A contains student names and particulars. Table B contains student names, test dates and scores.
I created a relationship between these 2 tables and set the field Name = Name. In the "Edit Relationship" window, I checked the boxes under Table B "Allow create of records in this table via this relationship" and "Delete related records.......".
When I created a new student record in A, I thought this new student will also appear as a new record in Table B. Mine doesn't work like this.
Can anyone advise where did I go wrong? Thanks in advance.