Relating Tables in Crystal

[Lucieann]

What kind of damage will it do if you relate the same field in multiple tables? For example, cna you relate one field in table A to fields with the same data in tables B and C?

 

[synapsevampire]

Sure, you can do this.

You need to understand your database though (potential one to many concerns/cartesian products, etc.), and the types of joins possible.

I'd do a little reading on how databases work, as this is not really Crystal specific:

http://hotwired.lycos.com/webmonkey/backend/databases/tutorials/tutorial3.html

-k

 

[FVTrainer]

One thing to remember, as well, is that Crystal is read-only against your database. So it's not going to damage data. (Well, if you base your report on a stored procedure, that procedure can update or change data, but Crystal itself doesn't modify your data). So the worst you can do is create a join that just returns too many records and serverly slows down your server, which can make a lot of your fellow workers very unhappy (assuming you're running on a server like Oracle or SQL Server). Which is why I would strongly echo Synapse's statement that you need to understand your database. Cartesian products are rarely your friend.