>I have the grid showing the many side. But now how do I populate the grid correctly? If I use the table the grid calls all the records. If I use the SQL statement I am not able to change the data in the grid. Please Help.

I think just setting the relationship in the DE will do it for you. Have you tried this?