ContributionsMost RecentMost LikesSolutionsCreating a form template that has some pre-selected tasks in it. I am creating a work order. I have the form set up, and it makes sense. However, we have a series of tasks that are common; I want them to automatically be included in the form when the new work order is created. Tasks already have their own app (see bottom picture) ------------------------------ Sid Fontoura ------------------------------ Parent- Child table lookup not showing data Above are 4 pictures of what I am experiencing. I had thought I had established a correct parent/child relationship. I have data in Work Order table "Status". I want that data showing up in Shop Labour. I also have a specific filter that states that to not show results if the work order status is "complete" or "cancelled." As you can see in the bottom image, I am getting data from a work order (3225) that is marked "complete" and also the Work Order - "Status" column is blank. What am I doing wrong? ------------------------------ Sid Fontoura ------------------------------ Re: Calculating a sum of vacation days used this fiscal year back to previous fiscal year startOf course! Thank you for your help! ------------------------------ Sid Fontoura ------------------------------ Calculating a sum of vacation days used this fiscal year back to previous fiscal year startI am trying to calculate an employee's owed vacation days. I want to make sure I capture all of the days they might be owed, so I want to include the total used this fiscal year plus the total consumed the previous fiscal year (in case there is any carry over). Fiscal years go 1 Jan to 31 Dec, so I want to calculate a sum from TODAY to 1 Jan of the previous year. ------------------------------ Sid Fontoura ------------------------------