| Author: sandeep 14 Jul 2008 | Member Level: Gold | Rating: Points: 3 |
hello first create 1 view in database. view is same like table but more than 1 table's data we can put in view..... then create crystal report for this view.......
|
| Author: venkatesan 14 Jul 2008 | Member Level: Diamond | Rating: Points: 3 |
U should have foreignkey relationship for the other two tables
ex: first table UID as primary key then other two table should have the column UID ,
then we will use join in query to acces the specific columns..
Regards, M.Venkatesan.
Please remember to Rate “Excellent or Good or Poor”
|
| Author: vidhya 14 Jul 2008 | Member Level: Gold | Rating: Points: 5 |
i ahve created one view in my database.. i want to know how to relate each table...... whether we have to use the id for next table
i have created two tables and i have Userid in the 1st table and in my next table i have invoice number .... i have put the elemetry fro the next table using userid from the 1st table ..
tell is it a right way r not...
else give me any websit .. or exzpmle
|