I Need to create a report where if the client speaks english it prints and english consent or if the client speaks spanish it prints a spanish consent. With that said the report basically pulls a signature field and the text that should change with the language will be in a text box.

 

I will be using 2 tables

 

client_consent

client_demographics

 

the client consent table holds the signature and date field and the client demographics table holds the language field that should drive the report. I dont know if this matters but i would like the default language to be english.

 

thank you