General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Evan, I'm having a really similar problem with a grid based on a child table that is not refreshing correctly when I move the record pointer in the parent.
>
>The relations are set fine in the DE, but I don't have any set up for the grid based on the child table. What's the general rule of thumb for setting relations within the grid's properties?
I just want to state again that I prefer to use the grid for the relations. Other developers may prefer to use the DE. I find the grid to be more stable for the way I work. That said...
You need to set the following properties in the grid:
Childorder && index in child table with order for child recs
Linkmaster && parent table
RecordSource && child table
RelationalExpr && an expression that relates the parent fields to the childorder index
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only