Trying to build connected records
Table 1 - Requirements
Table 2 - Meetings
For each requirement there can be multiple meetings, owned by separate sales rep.
I already have these two tables, Now if SalesPerson_A has a Meeting_1 for Requirement_1 then an associated record is created in Table 2 - Meetings, but if the same SalesPerson_A has 5-7 follow up meetings for the same Requirement_1 then 5-7 more separate associates records are created and we have created a field dropdown - Round of meeting where we are manually managing, 1st, 2nd, 3rd, etc to keep track, then we are manually copy pasting the previous meetings links in the coming up meeting to access them. this is too outdated and time taking.
Also SalesPerson_B can also have a Meeting_1 for Requirement_1 then another new record is created in Table 2 - Meetings n for further follow ups its same manual way.
What i want to achieve is that if SalesPerson_A has a Meeting_1 for Requirement_1 then an associated record is created in Table 2, Called Record 1, then I can have someway to keep all the next rounds of meeting under the same, each meeting is different, we have different agenda, people we are meeting, meeting links to join so for each record here there is a lot of information we need to enter, also various fields about how that meeting went, etc. need to manage this separately for each round. what can be the best way to achieve it.
we never know we will 1 only or 7 or 10 meetings for a requirement.