using a variable to define database relations

[LMay_(Guest)]

I use a ticket-sales database, and it has a "mainsale" database, which I use as the master db, a customer db link, master show info link, and multiple seating chart links for each different show. For years I have had to set up separate reports for each different show, because each is linked to its own seating chart that tracks which price codes and which customer # are attached to the purchased seat. I was hoping that version 9 would allow me to somehow tell R&R to link to whatever database was defined in the "mainsale" variable field, "chartname." But I can^t figure out how to do it - is it still not possible or am I having brain freeze?____While we^re at it, my life would be made much easier if it were possible to have a variable that would count the number of copies printed, so I could have R&R print tickets for multiple price categories that are sold to the same person, in one record: currently I have to have employees enter separate records for each price category purchased for general admission shows in order for R&R to not print all their tickets at the same price code. In other words, I would like to tell R&R to print the number of records that appears in the field "adult_tix", then go to "child_tix" and print the number of records in that field, etc. Is that possible?____Thnaks!

[kfleming]

You could set up a relation to each seating chart database and then do a conditional field that brings back the appropriate linked database field based on the value of the pointer field.______Kathleen__R&R Support

[FRED_EMMERICH_(Guest)]

I have used the .dll to dynamically change table names at run time and my app supplies those names to R&R. If you don^t program, then this won^t work, or if those different related tables are not the same, since the report will be looking for certain fields.