jcclow

Those are all really good questions to ask before I get too far along...thank you. Lets's start at the top... Ideally, I want to be able to sort/view the data a couple of different ways By Engineer - Only the projects assigned to the engineer would show By Project - If project 536 consisted of sub projects 1st floor, 2nd floor, etc. I would want to see all projects associated with project #536 For our Monday morning team meeting, we would want to be able to see all open projects in the following format... [Project #] - [Project Name] - [Sub-project (if one exists)] - [PM] - [Engineer]- [Install Date] - [Status] etc. They are identical. Does this then become a boolean where if there is a sub-project, a new record will be added with the Project Number, Project Name, Sub-project Name, PM, Engineer, etc.?

Beginner FileMaker user here. I am working through the Philosophy of FileMaker series on Udemy and have a question about a project I'm working on. I am building a FileMaker project to track projects at the shop I work at. Sometimes we have projects that we break into smaller projects and assign different engineers to the sub-projects, but the sub-projects are always part of a larger project that has a specific number per overarching project. For example, project 584 might be Charleston Courthouse, but it gets split into 1st floor, 2nd floor etc. Sometimes we don't break the projects up and the whole project goes to one engineer. I have a Project Manager table, an Engineer table, a Projects table, but I am wondering how to handle when the project gets split into sub-projects. I am leaning towards the sub-projects being a separate table because sometimes the project doesn't get split up and I think trying to track projects that get split up in the same table as projects that don't get split up will be confusing. So all projects will be represented in the Projects table, but projects that get split up will have a relationship with a separate table called Sub Projects where each sub project gets its own line. I'd love to hear what some more seasoned FileMaker developers would do.