>>I have a many to many relationship, using an intermediate table to link two tables in a database. When I create the relations and watch the browse windows, everything seems to work fine. As I step from record to record in the first table, the intermediate table's browse displays the expected records, and the last table also displays only the expected records.
>>
>>When I have my FORM running, however, with a grid pointing to the last table, it shows ALL the records. Is this normal behavior?
>>
>>Do I need to create a VIEW and refresh it every time I go to a new record to make this work properly?
>>
>>TIA
>
>Yes, View/Cursor is normal solution.
Wow! That response was quick! The UT is a fabulous resource (as are you, Ed - Thanks)!
And if I use SQL as a recordsource for the grid, how do I force it to requery when I change from record to record?
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site