I have 3 tables, Application, Term and Term2. The Term tables are basicly copies of each other.
The Report is filled with junk from Application but some fields like Termination Date come from either Term or Term2.
If the application doesnt have a record in Term how would I make the report check Term2 table? Right now the report is working fine by only using Term table. I was thinking of making 2 details, identical copies of each other and putting data from Term on one and data from Term2 on another and then supressing the details if there is no data in either one. Perhaps there is a better way to do this? All suggestions welcome
thank you.
The Report is filled with junk from Application but some fields like Termination Date come from either Term or Term2.
If the application doesnt have a record in Term how would I make the report check Term2 table? Right now the report is working fine by only using Term table. I was thinking of making 2 details, identical copies of each other and putting data from Term on one and data from Term2 on another and then supressing the details if there is no data in either one. Perhaps there is a better way to do this? All suggestions welcome
thank you.