Is it possible to have 3 different portals on the same layout? I have 3 departments each tracking their own time and materials. They do this with a unique relationship between the dept. and our main job ticketing database. I want to be able to evaluate all 3 departments at the end of a job. My though is that I would try an put each of their portals on one layout. Doable?

Yes. But you need some way to positively (and permanently) identify each department. Either a short name that will NEVER change, or a unique auto-enter ID (from a small Departments table).

Then create a calculation field, in the parent table, like:

z_cDept_ID_1, = 1

Relate that to the child table, above field =:Dept_ID in the child table (which would also be 1). Add another relationship critieria for Job, or whatever the parent ID is.

Repeat for each Department (2, 3, etc.).

There are more dynamic methods, which would read these IDs from a Dept table. There are clunkier methods which would use a name instead of an ID. But it comes to much the same thing.

You should try these things yourself, it will help in your learning curve.

Short answer is, you can have more than one portal on a layout.

I would start by making one portal, get it working, than do the next, and so on. That way you will keep your confusion to a minimum. It can get confusing when trying to do this all at once, so be mindful of which fields, go with which relationship.

If you have problems, you can post a copy of your file. The benefit of this is that, we will use your files, fields, relationships, etc. in helping you.

Lee

Hi Fenton,

I see you beat me to the punch. LOL

I'll leave my post, as it gives a little different light than yours. Also, I thought the OP stated that they have unique IDs, but this will put hat to the test too.

Lee