Display multiple records of same table via portal

[Rhodiesan]

Hi,

I'm trying to create a table [Table A] such that each record in table A relates to a particular record in Table B. I would also like displayed (via portal, i assume) in Table A, information from one or more different records in Table B, but i haven't been able to get it to work.

Basically, each record in Table A contains information about a unique contract. Table B contains information about our sub-contractors. While each sub-contractor will have a unique contract for each program, several sub-contractors may work on one program (each requiring their own contract), and i would like the contracted individual to see who it is they will be working with.

When i try to add more than one field to Table A, requesting info from a Table B record, it assumes they are each referring to the same Table B key, and once one is filled, the rest are auto-filled with information from the same record.

Is is possible to have one Table B record relate, but several others be visible on the same page?

Thanks!

Kevin

[comment]

Please don't use "Table A", "Table B", etc. - it's very difficult to follow.

It seems like you should have three tables: Programs, Contracts and Subcontractors, related as:

Programs -< Contracts >- Subcontractors

i would like the contracted individual to see who it is they will be working with.

You can show all sub-contractors of a program in a portal placed on a layout of Programs. In order to show the "other" sub-contractors in the same program from the context of the Subcontractors table, you need to select a program first.

[Rhodiesan]

Ah... Table C!!

Thanks for the advice, Comment. So simple, and i think it will work very well.

best,

K

[comment]

Ah... Table C!!

LOL