ContributionsMost RecentMost LikesSolutionsRe: Basic Automation Question Hey Mark, thanks again for your help. It was a key field issue and now works great, thank you! ------------------------------ Mike Sanders Mike ------------------------------ Basic Automation Question Hi, I have two tables (Projects and Tracker) related by Project Name. When a new Project name is added to the Projects table, i want to create a record (with the Project name) in the Tracker table. I have tried to create a QB Action but this part doesn't work: The Related MDU (Project Name) always comes in blank. How do I fix it? ------------------------------ Mike ------------------------------ Date Modified Colors How would i create color codes for the number of days since a record was modified? For example, if a record was modified today, make it green. If it was modified in the past 3 days, yellow and more than 3 days, red. ------------------------------ Mike S ------------------------------ Reporting from Multiple Tables Hi All, I have an app with 4 tables. Projects contains basic project information, such as Name, Address, Size, etc. Three other tables contain details regarding milestones for project completion. MS1, MS2 and MS3 each contain details about the milestones to include a completion date for each one. How do I generate a report showing the Project Name, MS1 Completion Date, MS2 Completion Date and MS3 Completion Date. Thanks for your help. ------------------------------ Mike Sanders ------------------------------ Re: Creating Relationships For 3 TablesI really appreciate your help Mike. Let me give you more details: Table 1 - Projects, Table 2 - Tracker2, Table 3 - Pole Location Relationship 1: Relationship 2: ------------------------------ Mike Sanders ------------------------------ Re: Creating Relationships For 3 TablesThanks for your help! Any idea what would cause Active Project - MS1 (date field) to be empty. This report comes from Table 3. ------------------------------ Mike Sanders ------------------------------ Creating Relationships For 3 TablesTable 1 fields are Project Name and Site ID Table 2 fields are MS1 Date and MS2 Date Table 3 fields are Pole Name and Cost How do I create the relationships for Table 3 to produce a report with the following info: Project Name, Site ID, Cost, MS1 Date Tables 1 and 2 have a 1 to 1 relationship Tables 2 and 3 have a 1 to many relationship Any help is greatly appreciated! ------------------------------ Mike S ------------------------------ Empty FieldI don't know how to describe this question, but here goes. I have 3 tables. Table 1 is a parent to Table 2 and Table 3. Table 2 is a parent to Table 3. I have a report in Table 3 that gets name from Table 1 and Date from Table 2, along with several fields from Table 3. The Date from Table 2 does not come in, it's all blanks. Any idea what I'm doing wrong? ------------------------------ Mike S ------------------------------ Re: Checking Date FieldsAwesome, thanks again Mark! ------------------------------ Mike Sanders ------------------------------ Re: Checking Date FieldsOne more question. Can you override the formula date at all? ------------------------------ Mike Sanders ------------------------------