Automating a Client Information Database with Appointment Info

Hey there!

I currently have a sharepoint list to hold my team's client information (CI List) and I'm looking at making one that holds all the info on appointments (i.e. length of appointments, how many, type of appointment etc.) (Appt List).

Not sure if it's important but both of these lists take data straight from respective Forms.

For analysis purposes though, I'm hoping to find a way to compare information across the 2 lists. We use a common client ID for both lists but different information in both, one has demographic info, the other has appt info.

An example of what I'd want to be able to find is how many appts did we have with male vs. female clients or how many of our clients accessing a certain type of appt have disabilities.

I know that I could use the lookup column, but that sounds like an awfully manual way of doing it, with probably hundreds of clients by the time we run the data.

I also know that a work around would be to have my team just fill in the demographic information into the Appt List, but it seems like double-handling since we have that exact info nearby.

I really appreciate any help the community can give me!!
Thank you!