Then that record and Data gets automatically created across all the other tables
You need to rethink that. Entering this data once in the performance table should be all that you need. It should then be accessible via relationships from any of the other tables and the layouts used to view/edit them.
I suspect the issue lies with your relationship. You appear to have one table for performances and one for seating. It sounds like you have one record for each seat, but I could be guessing wrong here. What relationship have you set up to link these two tables? (especially given that one button to one seat layout that you have described here.)