Bilingual Reports

[drukawski]

I am trying to create a database that will generate a report from data in my table (lets call it tblprocedures). Now, what I want to do is generate a Spanish version, as well as an English version of a report based on data entries from tblprocedures. I have already designed the English and Spanish reports themselves. I have also created a form so that a user can input data(frmprocedures) with all the entries for things that don't need to be translated (ie. numbers, names, etc..). All easy stuff so far, my problem is I want to make it so that the user can select through check boxes on the form, which pieces of information apply to the current record, then when the user generates the English report the database will print the English version of the information related to each checkbox if its checked, and if they generate the Spanish version of the report, the Spanish version of the data related to each checkbox if its checked will print.

My thinking was to use a second table (tbltranslation) and and pull the English or Spanish (based on which report was generated by the user) version of each data entry and print them to a text box on the report and use an if then statement to print data only if its box is checked. However, I am unsure how to do this. I can't really establish a primary key, as the fields that would be in tbltranslation in no way relates to any one field in tblprocedures (is this a many to many relationship?), and I am pretty sketch on the whole programming side of this. I took programming classes in highschool and college but its been awhile.

Any help or direction would be greatly appreciated.

[drukawski]

In thinking through my problem and trying to figure out the general method of achieving what I want, I think I could get this to work by writing an if, then statement into the text box on each of my reports something to the extent of: "if blah checked = true, then write whats in record blah field english, on table tbltranslation, if blurb checked = true, then write whats in record blurb, field english, on table tbltranslation" and the same with spanish but for its respective translation...

does this sound like the right path to pursue or is my train of thought flawed in some significant way?

[drukawski]

still no answers....

[JKing]

Hi there. I believe the reason no one has answered this question as of yet is because it's quite unclear. I've read it over several times and I'm still not exactly sure what you are looking to do.

Do you want to create a filter for your reports based on check boxes? If so what values are being determined by these check boxes? Could you give a small example? Something more elaborate and descriptive than "some check boxes to determine pieces of information".