Hi @Chris_Connelly - you can share views of tables with restricted data, but, with 6500 clients, I wouldn’t recommend this approach for you - way too many views!
A different, but better (IMHO), approach would be to use the AT API and show clients a single record in a purpose-built web app (rather than WP). Doesn’t need to be too complicated - could be done quite simply.
Each record in AT has a unique Record ID - example: recwqphkExTf50wa6 (“rec”, plus a random string of letters and numbers). There’s no sequence to these records within a base.
You could use the API to display a client’s data at the URL:
if you were happy that, in practice, that these can’t be guessed (and remember that a record must be tied to a base ID and an API key to be called via the API so some additional security here) or if you are after more security, implement an account system where this ID is tied to an email address.
Hope this helps - appreciate it isn’t “easy”, but a web developer would be able to put this together pretty quickly. You’d also have the bonus that by using the API the display of the data could match your corporate branding so might look more professional.