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
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site