>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.
Edward Pikman
Independent Consultant