Joining Data from 2 Forms in Views

Joining Data from 2 Forms in Views

I am building a database that tracks walking records by both individuals and by teams. I have 2 forms, one collects new members data including the team they will be on and the other form collects the info on how much the individual has walked and pulls the employee name from the first form via a lookup form. I am now wanting to build a view with info from both forms(such as teams total mileage, etc.)

I have not been able to figure out how to get the data from both forms into one view. It does not give me the option when I am building. Any help would be much appreciated.