>>>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?
You better use view alias as recordsource and requery() view when necessary.
Edward Pikman
Independent Consultant