Hi All,
I am new to crystal reports and i want to know how to link the following tables. I have two tables with the follwing fields

Table1:
state
sys_date
field3
field4
field5

Table2:
state
sys_date
cons
filed6
field7


i already have a crystal report generated for table 1 ( which is grouped on state(group1) and then on sys_date(group2)), now i want the field cons from table 2 to be included into that report( i want to use this value in the group1 footer)....i.e. Please let me know how can we get the cons value for a specific state and sys_date combination.. Please let me know if i am not clear enough in my explanation. Thanks for your time..uma