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