Search results

  1. G

    Update child table based on Parent Duplicates

    I use an autonumber in my student table with a number in my auditions table because people can have the same last name and the same first name. Not likely, but possible.
  2. G

    Update child table based on Parent Duplicates

    Thank you for your reply. However my goal was not to delete the tblStudents, it was to change the related table so that the three instances of one name would be consolidated. What I ended up doing is writing a script that went through each record in the student table and compared it with each...
  3. G

    Update child table based on Parent Duplicates

    Good Day! I am working on an audition tracking database that was implemented before I stared working here. It was originally designed poorly with no normalization and each audition got a new record regardless if that individual has taken one before. I have since split it into five tables. For...
Back
Top Bottom