Filter parent records within child record grid edit based on other parent selection
Hi all, I've implemented solutions similar to this in the past (filtering child records based on grid edit overrides & forms, etc), but I'm really struggling to figure this one out. Here's the scenario: I've got a table "jobs", which is a child table of "venues". On the Jobs form, I need users to be able to select an on-site contact from a list filtered based on their selection of a grandparent "venue" record. Currently, I've got a table "contacts" which is a child of "venues". I've created an intermediary relationship table "on-site contacts" which is a child of both "jobs" and of "contacts" to connect the two. I've tried adding a grid-edit child record report of "on-site contacts" to the jobs form, and attempted to filter it so that it only shows records in which "contact-related venue" is equal to "job-related venue", but with the grid edit report, job-related venue does not populate until the form is saved and the child record is officially created. Does anyone have a solution to accomplish something similar? I suppose I could flip the relationship and try and make on-site contact a parent of jobs, but I'd like for users to be able to add multiple contacts as needed. Thank you! #Gridedit #Search #filters #Many-to-Many ------------------------------ Elena Larrabee ------------------------------
Connecting Multiple Tables - Many to Many?
I'm trying to relate two tables. The background - we are using the app to track contacts. One type of contact is "Writers" which would be associated with one or more "Outlet". An outlet can also be associated with more than one writer. Quick Base doesn't give the option to use a report link/drop down as a multi-select function, so I'm not sure how to associate multiple records from both tables. In the writers table, you should be able to see all of the outlets associated with that writer. And in the outlets table, be able to see all associated writers. Right now, I would have to create multiple records of the same Outlet to associate multiple Writers. ------------------------------ Chelsea Giacchi ------------------------------
Cannot Dynamic Filter in Many to Many Relationship
I am creating a table for all of my Company Procedures so that we can work on documenting them for new and existing employees. As this list can get a bit long I want to be able to associate a Department with them so if I work in Accounting, for example, I can dynamic filter all of the procedures just affecting Accounting. Here is my structure: Departments < Department Procedure Join Table > Procedures I created the join table because each department can have many procedures and each procedure can have many departures. On the report I can only do the following. I cannot seem to expose the department field as a dynamic filter for some reason. Not sure what I did wrong here or what is wrong with my logic. ------------------------------ Ivan Weiss ------------------------------
