LaserGecko Posted April 1, 2008 Share Posted April 1, 2008 Hi everyone, I think I'm stuck in one of those "can't find how FMP wants me to do it" loops and would sure appreciate a pointer in the right direction. I have a "Projects" database that's used as a reference in a TimeSheet allocation database. "Projects" contains the Project Code (numerical), Name, Unit Code (different parts per project), Unit Name, and an Active field. If the Active field is true, two Calculation fields concatenate the codes and names for both Project and Units. These calculations are the basis of the value lists in the TimeSheet. (If it's not "Active", then it doesn't show up in the Drop Down List Currently, I make multiple copies of a record in Projects for each different Unit. I had considered making a Units database and that might be the easier way to go. In the timesheet, I would like for only the Units related to the selected Project to show. As you can guess, right now all of the Units show up regardless of what is selected in the "Project" field. I know what I want to do, but can't find the right search terms to find the answer. The database isn't in use yet, so changing it isn't a big deal at this point in time but I do need to get it up and running ASAP. Thanks in advance! Link to comment Share on other sites More sharing options...
David Head Posted April 1, 2008 Share Posted April 1, 2008 I think you are right - you need a separate table for Units. One Project has many Units but each Unit relates to one and only one Project. Then you need to set up your Units value list as a conditional value list. If you search the forum for that term, you will find lots of examples. Link to comment Share on other sites More sharing options...
LaserGecko Posted April 2, 2008 Author Share Posted April 2, 2008 Hi David, Thanks for clearing the air. Sometimes, getting your head around what FMPro needs is the biggest hurdle! Link to comment Share on other sites More sharing options...
LaserGecko Posted June 12, 2008 Author Share Posted June 12, 2008 Odd thing popping up with this now that people are doing different "Projects" each day.... Should Conditional Value Lists work with Repeating Fields? The "Units" value list isn't changing to match the entry in the same repetition of of the "Project" field. Should it or did I break something? Thanks! Link to comment Share on other sites More sharing options...
LaserGecko Posted June 12, 2008 Author Share Posted June 12, 2008 Fixed now. I got rid of the repeating field and made individual fields, then made new relationships. Might not be pretty, but it works! Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts