Hi everyone, I have a question for the pros amongst you.

The situation is as follows: I have a layout (1) that displays data from table 1. I have a second table (2) and I want to display data from table 2 through a portal on layout 1.

so far so good .. this all works ..

but here comes the kicker ..

Table 1 has a diver identifier number (e.g. 1-10)

Table 2 has records (diving projects) that contain this customer number in multiple fields. For example: diver in charge, dive team member, dive team leader, surface attendant, etc.

I want to portal in Layout 1 (that displays data from Table 2) to display ALL records from Table 2 that contain the identifier number in any of the related fields (aka. wherever the numbers shows up, that record should be displayed)

This allows me to tell that diver who logs into the database:

You are involved in the following 5 projects (if that's how often his number shows up). Regardless of what capacity he holds in that particular project ..

Any body have any ideas??

I realized that there are the AND operators in the relationship graph, really, all I want is to change that to a OR .. but can't seem to figure it out ..

Help is greatly appreciated! thanks a lot

Mat :)

In table 2 create a stored calculation of

List ( diver in charge; dive team member; dive team leader; surface attendant )

Assuming that these fields are diverIDs, the calc result will look like

2

14

32

etc.

Then make the portal relationship from the diverID number to the new calc field.

This will show you records where the diver ID in ANY of those fields

Hi mr_vodka

I'm not quite sure that we are talking about the same thing (at least my brain does not follow your instructions ). I'll try again:

table 1 has two fields: DiverName and DiverNumber

DiverNumber is a unique identifier (kinda like a student number).

table 2 deals with diver projects. Its fields are: ProjectName, ProjectDirector, DiverInCharge, DivePersonell1, DivePersonell2

Now, I need a portal in layout1 (which displays data of table1) to show data from table 2.

What I forgot to mention is that a diver logs into the database with a unique username. Layout1 (displaying table1) shows very specific data to THAT diver .. What I want the portal to show is all diving projects that contain the diver's unique DiverNumber.

e.g.

in project 1, the logged in diver could be project director

in project 2 he could be a DivePersonnel1

in project 3 he could be DiverInCharge

so, these three fields would all contain that user's unique identifier ..

What I would like to see in the portal is this:

SerialNumber - ProjectName1 - ProjectDirector - DiverinCharge

As you can see, the capacity fields don't necessarily show up in the portal, yet we know that the diver is involved in that project in some capacity ..

Makes more sense?

thanks for your help!

M.

got it!

that was easy .. I actually did figure it out .. the first cup of coffee was needed ..

thanks a lot for your help!!

cheers

m