I've read a number of items on this but can't seem to find any good (or
should I say clear) examples of how to display data from more than one
table in a portal row. Unfortunately, my understanding of the use of
join tables is slim to none and this appears to be how many solutions
are described. I am working on a human resources database where the
primary table contains basic employee information and other tables hold
various other pieces of data related to each employee.

For example:

Employees is the main table (primary key is Employee ID)

Other tables are:

Reviews
Milstones
Counseling


Throughout the course of the year, an employee might get a review,
acheive a milestone, or be counseled. Is there an easy way to get all
of the data from each of these three tables rolled up into one portal
sorted by date? The reason they are broken out like this is because
users require different access levels to view edit or add records to
the various tables.

I realize the solution offered may be to put Reviews, Milestones,
Counsleing all in the same table or do some sort of tabbed interface, I
was just hoping for a more robust solution where I might learn a bit
more about multiple relationships in FM 7 or 8 and get a nice
presentation of the data at the same time.

Thanks in advance...

Well, what you want is for data from all three tables to be "collated" into
a single list. For that to happen the must be a table in which all those
items are combined, one record per event. You can manage the access levels
within that single table -- separating them is not required.

If you think about it the three tables are really very much alike. Each
would have:

- Date/Time
- Title/Summary
- Description
- Attached Documents
- Type (Review/Milestone/Counseling)

As for the access levels you can specify who can access and/or edit those
records, and even build logic into the relationship itself to suppress their
very existence.


"Hahnium" <bill.hahn (AT) gistandherlin (DOT) com> wrote