Newbies rshboston Posted December 4, 2002 Newbies Share Posted December 4, 2002 Sorry if this has already been covered. I have a job tracking solution made up of 2 files: Jobs.fp5 and Job Tasks.fp5. Tasks for each job asks are marked as either active or inactive. The files are related by job number. On one layout of the Job.fp5 file, a portal shows all tasks for the specific job number. This works fine, but I'd also like to create 2 other layouts in the Jobs.fp5 file - one with a portal that shows just active job tasks and another layout with a portal that shows just inactive job tasks I assume I have to create 2 additional relationships between the 2 files and probably some fields, but don't how to go about it. Can anyone help? Thanks in advance for any assistance. Link to comment Share on other sites More sharing options...
jasonwood Posted December 4, 2002 Share Posted December 4, 2002 I think you have to create a concatenated field containing job number and status. In the job tasks database you will have a calculation field: calcStatus = jobNumber & jobStatus it might look like 55555active for example. in the jobs database you will have two new calculation fields, one for active and one for inactive. These will be the keys for a relationship. calcActive = jobNumber & "active" calcInactive = jobNumber & "inactive" Then simply make a relationship to relate calcActive to jobTasks::calcStatus And then one for calcInactive to jobTasks::calcStatus The thing I'm not so sure on is the options you need to select to make a calculation work properly in a relationship. Stored? Unstored? Maybe someone else can remind me how this works? Link to comment Share on other sites More sharing options...
Newbies rshboston Posted December 5, 2002 Author Newbies Share Posted December 5, 2002 I tried what you suggested, but something isn't working. I have one job with 7 tasks (6 active & 1 inactive). When I set up a portal in the Jobs file using a relationship based soley on Job number, it shows all 7 tasks - as it should. To show just active jobs, I created a calc field in the Jobs file named Tasks_Active (=Job Number & "Active"). I then set up a calc field in the Job Tasks file named Task_State Calc (=Job Number & Task State). Next, I created a new relationship in the Jobs file called Active Tasks based on the 2 newly created fields: (Tasks_Active = :: Task_State Calc) I then created a layout with a potal using the new relationship. The result is not 6 active tasks, but 7 tasks. And not 7 different tasks, but the same task listed 7 times!! I tried the opposite (similar set up, but for inactive tasks). The result was even more surprising - it showed 2 tasks. Not different ones, but the same task twice!!! I tried turning storage options on anf off, but that didn't seem to make a difference. I'm baffled. Any ideas? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7947 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now