Hi,

I hope this is the right place to post.

I've got a database for storage details of drawings which we produce for individual projects and various related tables which allow details of revisions to be stored together with when sets of drawings are issued to clients and other members of the design team. The tables are basically as follows:

Projects > Drawings > Drawing Revisions

Projects> Issue Sheets > Issued drawings (Based on the Drawing Revisions)

Drawings Issued to > Issue Sheets

This all works fine and allows me to produce individual drawing issue sheets which lists the drawings I have issued to a set of clients on a particulat occasion. What I need hower is as follows:

A report which is based on the project which will list all the drawings on the lft hand side as a vertical list. There are then a series of vertical columns which relate to each drawing issue with a date at the top and the drawing revision letter against each drawing that was included in that drawing issue.

The problem would be sorted if we could have horizntal/ 2 directional portals, but I can't seem to get my head around the best way to show this.

I hope I've explained this enough and someone might be able to help.

I've attached a file which should help explain what I'm trying to achieve.

Any queries, I'll be pleased to clarify the above.

Many thanks,

Ian

See here: http://fmforums.com/...-matrix-portal/

and here: http://fmforums.com/forum/topic/71939-getting-more-out-of-filtered-portals-4horizontal-portal/

Edited April 8, 201213 yr by imoree

Thanks for that. for some reason I can't download the example in the first link but I can for the second. Do you know if there is much difference in what they show?

Thanks,

Ian

I've had a look at the horizontal portal example, but I'm not sure how you could translate this into a table where the rows could contain anything from 1 to 100+ items and the columns being the line items relating to the date when any/ all or some of the drawings were issued. I'm thinking the matrix example might be more what I need... any thoughts on why this can't be downloaded?

Much appreciated.

Ian