>I am not able to figure out how to create persistent relationship between two tables in the database designer. I am able to create relationships in the Data Environment by dragging fields from one table to another (ofcourse, I made the fields indexes in both the tables ) Your help is much appreciated.

Ensure that your primary keys have "primary" or "candidate" indexes. Then just drag and drop.