>>
>>- 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
Mandy, a grid (view or table driven) can ALSO contain fields from a table linked by a relation. For example, if you use the Person table as a child table to populate the grid (linked by your Agency Code I think), then instead of the Position CODE put Position.PosName. As long as you have the correct relation on Position Code in Position and Person, the correct Position Name will appear in the Grid.
HTH
Barbara Paltiel