leish2

Comment - You are on to something. Thanks you for opening my eyes. Sometimes I just get so deep into the way I have designed a solution that I can't pull far enough away to see clearly. I will consider merging the Addenda with the Projects. BTW - you are correct about the one-to-many relationship from Projects to Addenda. The Addenda were added after the fact so I created separate tables - the reason I did so is that they can create a bunch of Addenda but not all of them are "Active". They start as "Pending" and then move to "Active" or "Cancelled". Active means approved and the

Thanks for replying ... here goes: Here are the tables and relationships: Projects (key field is ProjectsID_k) ProjectsLineItems (child key is ProjectsID_kc) - this file is where the Task field is located. • Value List - ProjectTasksVL = gets related info from the Tasks field in ProjectsLineItems starting from Projects Timesheets (Key field is TSID_k) TimesheetsLineItems (child field is TSID_kc) - TimesheetsLineItems is related to Projects via the field "ProjectCode" which is entered via a pop-up list ... once this field is entered the "ProjectTasksVL" will show the cor

I am trying to combine 2 value lists into one - they are from 2 different tables and need to be use in a 3rd table. 1. TimesheetsTable = table where the TASKS value list needs to be available. 2. ProjectsTable = contains a value list of all the Tasks assigned to that Project. 3. AddendumTable = contains a value list of all the Tasks assigned to the Addendum. • In the TimesheetsTable the person chooses a Project 123 and based on that choice a pop-up displays the list of Tasks assigned to Project 123. Works like a charm. • Now, when we create an Addendum for Project 123 the A

I want to show summary data in a portal. • the Parent table is "Projects" • the Child table is "Tasks" - it contains TaskName (e.g. Design, Production, Printing) and TaskAmount (which is a number) I created a self-join relationship in the Child table to sum the data for TaskAmount and this works fine. But in the portal in the Parent table I see ALL the related TaskName records (each one showing the correct sum of TaskAmount). Something like this: Design 1200 Deisgn 1200 Design 1200 Production 250 Production 250 Printing 600 Printing 600 Printing