Crystal Report Designing (Data From more than 2 Tables)

[Plucky]

Hi there,
I am designing Crystal Report v8, I have 4 tables in single Access Database. How can i have datafields from other tables to insert in Crystal Report during desining.
Plz help,

[Hack]

I would suggest you not bind your report to anything of the tables, but rather, write an SQL SELECT query which gathers the data from all of the tables that you need, and bind your query to the report file.

[Plucky]

Hi hack,
Thank you very much for your help, you always be first in positive response.
Sorry friend, i don't know how to creat query in Access and don't know even any command of Crystal report related to SQL and son on..
i'm pretty novice in programming neither i have any teacher to learn VB, just you are the people from where i can gain as much as i can....
------
i simply inserting fields from Tables to crystal report, i want to complete it...
How you suggest about Data Environment Report? Can it be helpful for me in data printing and viewing..?
thanx advance for help,

[RobDog888]

You need to determine what fields and tables you need in your report first. Then you can create a Access query that gives you the results you need. Then in CR you can select the query (called a stored procedure in CR) as your recordsource.

Make sure you select Stored Procedures in your File > Options > Database tab > check "Stored Procedures" > click OK.