pipelines and portals

[cerulean]

Someone please help! I

[RalphL]

It looks like you are trying to have a portal within a portal. It doesn't work. I think your best bet is to put a button in the portal that will take you to record in conditions. Have a portal in that file that shows the operations for that condition.

[Oldfogey]

Cerulean,

You'll get your bottom smacked when the Moderator finds you've duplicated this post in another forum.

[Ender]

If you want to show all operations for a patient, you can relate from Patient to Operation by Patient::PatientID = Operation::PatientID. Use this for the relationship of the portal and all of its fields.

To display the conditions that the operation addresses in the same portal, use lookups in the Operation file to pull Condition information in as Operation records are created. Then add these lookup fields to the portal.

[RalphL]

NewCenturyData has a demo called "Separation Demo" that is very simillar to yours. They have company, contact and phone tables. Which could become Patient, Condition and Operation.

I don't remember where I found it. Maybe the FileMaker site.

Sorry this is an FMP 7 demo.

[sanne]

Oldfogey said:You'll get your bottom smacked when the Moderator finds you've duplicated this post in another forum.

Enlighten me: why would that be a problem?

It is very clear to me, that different forums are being visited by different people (althought, a few people visite every forum, but this is just a handfull, and you know who you are ).

If you want to have as many opinions as possible, it would be wise to post your situation in more than one forum.

It has amazed me to see that different forums can give you very different outcomes.

And it is this diversity that is so nice.

What frightens me, however, is the fact that if you post your situation in the same forum on different times, say a few weeks or months apart, you ALSO get different outcomes.

[Fitch]

If you post a question and get no response within a day or two, or you're not satisfied with the responses you receive, it's reasonable to post it again. However, if you post the same question in multiple forums all at once, you waste everyone's time.

I enjoy helping people solve their FileMaker problems. But when I spend time reading a question, formulating a solution, and composing a reply, it's very frustrating to find out that the question has already been answered elsewhere. So in essence, the question-asker took time that I could have spent helping someone else, and wasted it. You call it "wise," I call it selfish.

[Fitch]

Forgive me for continuing off-topic, but I wish to further "enlighten" you: the "handful" of people who visit every forum tend to be those of us who do the bulk of the question-answering. So those are the people you want to treat with some consideration, I would think.

As for the diversity of responses, that is just because FileMaker often allows many methods to accomplish a particular task. And, since we're all volunteers here, there's no guarantee that any particular person will happen across a particular question and choose or have time to respond. This "frightens" you?

One more thing about visiting forums. I don't think I'm alone in using the "Active Topics" link far more than browsing individual forums. So I don't even really pay attention to what forum I'm in. This is partly what makes duplicate postings a big annoyance.

Sorry to make an example of you -- but you asked!

[Lee Smith]

sanne said:

Enlighten me: why would that be a problem?

Tom gave you the bases of the complaint, but I would like to add the inline answers.

sanne and than went on to say:

It is very clear to me, that different forums are being visited by different people (althought, a few people visite every forum, but this is just a handfull, and you know who you are ).

If you want to have as many opinions as possible, it would be wise to post your situation in more than one forum.

It has amazed me to see that different forums can give you very different outcomes.

And it is this diversity that is so nice.

This would hold water if you were posting to different lists, but even at that you would be surprised of how many of us here participate in more than one list.

However, the Forum is really only one list, with several topic areas. It is hoped that the original poster can come close in picking a topic area, that represents their subject. If they don't, no one is going to get mad, and question will receive responses.

sanne and than went on to say:

What frightens me, however, is the fact that if you post your situation in the same forum on different times, say a few weeks or months apart, you ALSO get different outcomes.

As Tom stated, there is usually more than one way to "Skin a Cat". And timing is everything. Questions that seem the same as earlier postings, either by the same person or from a new poster, are usually referred to the older post for information when remembered by one of us.

Lastly, everyone here has supposedly signed an agreement to NOT double posts, along with other things having to do with List Etiquette.

Lee

[cerulean]

sorry i posted it twice. won't ever do it again.

now, is someone able to help?

[sanne]

Cerulean, if I'm not mistaken, your pipeline-question also exists in FileMaker Caf

[dbruggmann]

cerulean said:

The portal in the conditions file (which I know is redundant) displays the same operation in each row. The portal in the patient file displays that one operation in only the first row with the other rows empty.

If you get the same data in all the rows of the portal, that usually means, that these particular fields don't have the same relationship as the portal. The other reason I can think of, is that there is something wrong with the calculation, so it gives for all records the same result.

Furthermore, I think you need some more join files for your needs. But it is difficult to guess, how many and which one. I attach a sample file, which shows a simple and an advanced approach for showing pipelined data in portals. Both are not the solution for you, but maybe a starting point. Good luck!

Hospital.zip

[Ender]

Somewhere in there there were a couple of suggestions.

[Oldfogey]

Toldya! (We all know how desperately help is needed when it is needed. You're forgiven - sort of.)

"now, is someone able to help?" Yes, I did on your other post.

[RalphL]

Take a look at the sample files attached.

[cerulean]

As has been said, FM allows you to flay felines in multiple ways.

Skimming through a few ways of tackling the problem, pipelining/tunneling/shunting seems the most elegant solution. It's also suggested on the Nightwing site, and is further developed into their data matrix modelling method.

Looking at other posts,the problem I'm having has been encountered by others. The suggested reason for it is that the relationship of the portal is not the same as the relationship of the calculation field. I've tried every combination and permutation with regard to the relationship but am still not able to get it to work. Which is why I have listed all of the steps I've taken so that others might be able to point out exactly which step is incorrect.

In terms of alternative methods of skin removal, dbruggman's solution is interesting and I'm playing around with it. My main gripe with it is that it doesn;t offer the simplicity that shunting is supposed to.

As soon as stuffit downloads (16 mins to go) I'll have a look at RalphL's files.

Thanks all.

[Fitch]

cerulean, post your files and I'll take a look if I have time.