Hi all,
I have another problem which im assuming is a stupid one, but is causing problems with Crystal reports!
Bascially, I have 3 tables:
Clients, Logs, Projects
All the tables use Client_ID as the index...
Projects has the bulk of the data and has Links to Clients and Logs.
If I link Clients to Projects - everything works fine, I can create reports without problem.
however, If I link in and pull data from logs, it stops data coming from Clients.
After playing around, it seems either one or the other will run, but not both toghther.
The links themselves:
Projects --> log = Left outer join (not enforced)
Projects --> Clients = Left outer join (not enforced).
Any help would be greatly appreciated!
IP Logged
