>I amj trying to get a form to work with 3 tables, with one as the main table, but alas, it doth not work well.
>
>When I navigate through the table, I'd expect that the other fields, which are from other tables, would walk along with me visually, but they do not change their initial values when pressing the Previous or Next buttons.
>
>What am I doing wrong?
If you include tables into the DataEnvironment, the relations are often in the wrong order: from parent to child (as obtained from the permanent relations from the database). You usually want to have them in the opposite order: from child to parent. Delete the relation and create them again in the desired order.
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)