>
>- text box listing an agency/company name from the Agency table
>- grid with columns containing (for that specific agency/company) my position, first name, middle, last, phone, email fields.
>
>I have a Position table containing the Position Name, and a Person table containing the remaining fields. These two have a many-to-many relationship, thus a Contacts table exists containing the corresponding Position code and Person code for a specific position/person relationship. I also need the Agency Code from the Person table to filter only the Positions/People for the Agency listed in the text box at the "moment". Ideally I wanted a view with all of my fields needed for the grid which would be a Child of the Agency (Parent) table used in the text box. The "Next" button would change to the next Agency and thus refresh the grid with that Agency's contacts. I just can't seem to make the View a Child since I can't get an index on it. I keep thinking I'm missing something here, but think I'm too close to it at the moment to see it :-(.
>
>Your thoughts?


Have you tried using requery() when the agency changes to get the current records into the view? There is a requery method for listboxes and combo boxes, and a REQUERY() function to retrieve data for a sql view.

Greg