Hi B Karthick,
PMJIH. Actually there are a number of active forums right here in Wrox P2P. Among them is "Access VBA" http://p2p.wrox.com/access-vba-80/
Should you decide to post your question there, I would recommend you be more complete in your description of the problem. Specifically, I would suggest that you provide the SQL statement you are executing that returns no rows.
FWIW, Access will automatically create relationships between tables if you use the "Lookup Wizard..." when you are defining a field in a table. However, without seeing your SQL Statement I cannot say whether this created your problem or not.
Additionally, any relationships that Access may create behind the scenes will not automatically show in the Relationships form. To see all relationships that exist, open the Relationships form and from the menu select "Relationships" then "Show All".
Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group