Search the Community
Showing results for tags 'relationships portals'.
Found 2 results
I have a database that has the tables customers, estimates and inspections. (there are other tables as well) Anyway i currently have a layout per customer which has two portals, one that displays the estimates per customer, one that displays the inspections.When you click on one it takes you to the details of that "form". It works nicely but now they want to see one portal with the estimates & inspections listed in one portal. I thought what I would need is a join table but somehow I have become baffled. All three tables have the customer id. Inspections & Estimates have appliance ids as well. The end result is to view by customer all of the estimates and inspections per appliance id. I can make a sub summary report but they would like: Customer Appliance 123 Inspection Estimate Any suggestions would be greatly appreciated. I might need to be more descriptive. Caroline
The best way to pose the question is to fully describe what I want to do. I have an application that documents board meetings for an association. The base table for the layout is "Meetings". There is a related table named "Attendance" and another related table named "Trustees". On the layout is a portal to the Attendance table with Trustees Names and a checkbox to indicate if they are present or not. What I want to do is when they create a record in Meetings for a new meeting, I want to populate the Attendance table with records for each Trustee for the current meeting. Then all they must do is, for each trustee, indicate if they are present or not. So how do I read each record in the Trustee table and create a record for the new meeting in the Attendance table? thanks,