Help Showing Data from more than 3 related tables to datareport
Help needed desperately...
I have four tables...
PersonDetail-- having fields ID,Name,Cast,Religion etc....
PersonFamily--having fields ID,Member_Name,Relation,Age etc....
PersonAddress--having fields ID,CurrentAddress,District etc...
PersonHobbies--Having fields ID,Hobbies
the ID in personDetail is primary key and this ID has one-to-many relationship with all fields of ID
in rest tables.
I just want to print report in DataReport enabling user to input ID and print single person or all the records in the format...
Person ID...Name...Cast...Religion
-----Family Member data (more than one records with same ID) with respective fields.
-----Person Address with respective fields.
-----Person Hobbies (more than one records with same ID)
Help is needed urgently to finalize my application...
Thank you.
:cry: