I have been asked to do some work on a system developed some time ago by
another institution. The application is used to catalog images.

We recently loaded ~50,000 records from a flat file Access table into a
multi-table Filemaker database. We need to do a lot of clean up on the
lgeacy data to meet the data standards, so I've been asked to set up a
table layout that includes recods from multiple tables.

Table A has a record for each image in the collections.

Table B has a record for each work (site or artwork) depicted in an
image. There is a one-to-many relationship where 1 record in table B
may be related to many records in Table A.

It was not a problem to set up a table view in Table A with a portal to
table B.

What IS a problem is that Table B actually has its own one-to-many
relationship with Table C (each record in Table B may have links to
multiple records in Table C) and I need to include some data from that
table as well.

I was able to get this set up, but I only seem to be able to get the
first record from Table C. How do I get all records?

Leslie,

It should work fine in this situation. Perhaps the issue is that you are
viewing in Table View, which would only display the first value from Table
C? Try looking at the record as a form and see if all values from C are
filling in to the multi-line Portal.

Are all three tables related using the same field?

Bill

"Leslie Johnston" <johnston (AT) virginia (DOT) edu> wrote

No, they aren't related using the same field. A is related to B using
one field, and B is realted to C using another. I should also note that
this is running on FM Server 6 onm a Mac, with mixed Mac and PC clients.

You're right -- I hadn't checked in form view and it does look fine
there. The issue is that the users really, really want a table view,
because they want to be able to easily scan columns of data while
cleaning up the fields.

Is there a way to set up a table view that will accomodate this?

Bill Marriott wrote:

Yes.

You create multiple portals, each specified to show one record...

Portal 1: Initial row: 1, number of rows: 1
Portal 2: Initial row: 2, number of rows: 1
Portal 3: Initial row: 3, number of rows: 1
Portal 4: Initial row: 4, number of rows: 1
Portal 5: Initial row: 5, number of rows: 1

Each portal will get its own column in table view.

Bill

"Leslie Johnston" <johnston (AT) virginia (DOT) edu> wrote

What about selecting a row based on a value? For example, a row where
Qualifer="Primary".

Bill Marriott wrote:

Ah, trying to get a way to the other question you just posted...

No it doesn't work that way. You can only display the Nth row of a given
portal, not some row based on a conditional/calculated value.

For more info, see my forthcoming response to your other post...

Bill

"Leslie Johnston" <johnston (AT) virginia (DOT) edu> wrote

I'm just thinking through various possibilites for attacking the problem
.... <g>

I very much appreciate your time and insight into my questions.

Bill Marriott wrote: