General information
Category:
Forms & Form designer
>In a form I have a grid with RecordSource set to Table1.
I also have a textbox linked to a field of Table2.
>In the grid I want to see only related records to the current record of Table2.
>My grid has
>LinkMaster = Table2
>RelationalExpr = aField
>But the grid always shows the entire content of Table1 ???
>I tought this would work. Did I forget something.
>Thanks
need childorder property. can also try "goto recno("parent table")" in the grid init (or any other appropriate time), to reestablish the parent pointer, which should readjust the child pointer. can also try not having focus set on the grid when you do a grid.refresh.
i had many child/parent grids defined like you in the grids pem. dropped them all. i am a new vfp, so there are tricks i do not know - but my grids were so finicky that i could not stand it anymore. coming in the first time, if there were records to show in the grid they would show all the records. if there were no records to show, they would flicker with the last record of the data set (long enough i could read which record it was) then go blank. finally made a temp table with only the subset of records i needed and only displayed those.
most people on ut say to use a parameterized view. this was not appropriate for me. you need your tables to be in databases and unique indexes on the tables for update.
brenda
Previous
Next
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