Look up through file reference

[Steve19]

Hi, any help much appreciated

I have two main tables, People details and Company Details. They are connected by a table called Peepony which says who is connected to which company's and vica versa. This table appears as a portal in the layouts to the two main tables. When entering from the company details page it auto enters the company name and ID from the displayed record in the layout. You then select a name from a pop-up list which displays all names within the people details table. The field for People ID in the Peepony table is set to auto-enter from people details::people ID and they relationship has been made and seems good but it is not importing the ID into the field in the peepony table. The same problem happens when entering data in the peepony table from the People Details layout...

Any ideas, a bit of script maybe?

Thanks in advance

Steve

p's' please find attached the files concerned. A file reference is required.

[Ender]

This was answered on your thread in filemakerworld. Let us know if you still need help.