>thank you nancy for the tip. yes i was talking about the wizard in the one-2-many! im tryin to display a parent record on a page with a grid showing data from a child table. ive stripped out junk and dup records from the parent so as to have referencial integrity between the two files. i mainly want to know how to switch between them when adding a parent, child or both records on my page. any suggestions?

Well, you can do it on a page much the same way your wizard form does it. So, my thought was you could take what you learned from the wizard form for the data enviroment, relations, grid and text boxes, for example, and apply it to your new form. At least as a start.

Meanwhile, there a few ways to accomplish this. You can use a traditional SET RELATION, and use the Grid's properties for LinkMaster, ChildOrder, and RelationExpr, for example to synchronize the grid with the parent table. It actually works pretty well, and isn't terribly difficult.

You might want to use the Grid Builder to help you with this.

Another way is to use SQL-SELECT to create a cursor of the child records for the current parent record.

Do you have an idea of which route you would prefer?