A portal is like a lookup or overview showing all related records to a certain relationship.
What is your relationship between the 2 tables?
If it is between PK_Intranet and PK_Office then that won't work because the results won't be the same.
Please provide some more information.
Thank you for your reply.
Currently I have the fileds and tables setup in the following way:
PK_Intranet (Primary Key)
OfficeID (Foreign Key)
All name fields, such as first, last as well as address info
PK_Office (Primary Key)
IntranetID (Foreign Key)
I have a relationship built that ties PK_Intranet to (Intranet table) to IntranetID (Office table) together with the 'crows feet' on the Office table/IntranetID side.
To reitteate, I want to allow an Office layout the ability to view the fields of the Intranet fields via a portal.
Thanks again for your help.
You do not need the IntranetID in the Office table. It makes no sense to put the "child" id in the "parent" table, because there are many children for one parent; the parent primary id to the child's foreign key parent id is sufficient.
Thanks for your response
I removed it and now it looks like this:
But still no info that I entered into the Intranet table/fields show in the portal on the Office layout. I know it is something simple.
Make sure that PK_Office and OfficeID are the same field type (both number or both text for example) and truly have matching values.