Auto assign relationship to connected detail table

I have a client table (master table) The key field is the Record ID# I have a connected table (.csv via SFTP) of scheduled ads (detail table) I have included a field in the imported data named: Q...