Templates - Data Sources

[tobypsl]

I have a paradox recruitment database which holds records of jobs, clients and candidates. Every time a search is created to match candidates to jobs the results are stored in a review table. Each job has it's own review table named after the job code (taken from one of the fields in the jobs table) for example J000078. So every time a new job is entered and a search constructed a brand new review table is generated.

I have a very simple report that pulls candidates out of the review table and reports their contact nos. from the candidate table.

The problem is I keep having to change the data source table for each report. so was wondering if either of the following are possible :-

1. can I create some form of template that allows me to select the table each time the report is run ?

2. is it possible to select the table using a formula, the name of each review table is generated using a field in the jobs table. so is it possible to have a parameter that queries that table for open jobs then uses the value in that field as the name of the data source.

Option 2 would be favoured but I can see all sorts of problems, any advice appreciated. Iuse Crystal reports 8.5

 

[tobypsl]

did a search and came across the 'set location' property so I can now change the table source there. NOt ideal but it works.