General information
Category:
Forms & Form designer
>
>- 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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only