So I needed the database to hold just one record per representative,

If the representative ID is unique then you can catch the error later on and prevent 3 records from being added. Edits will use the last saved values though.