Sascha K

Thanks for the example! Why does it look so easy in that? I try to adjust it to my file. Yes, the table is for navigation purposes. normal search in list view doesn't appeal too much to my eye. But I will try now all techniques. If I may, I will come back to you once this problem is further "deveoped" - better solved. Thanks both of you! Thank god it is still daytime in the US, while everyone here is asleep. Sascha

hmmmm, good point. Let me think how that would relate and try the search option connected to the button. Any idea why a script works in the debugger, and not under normal circumstances? Thanks for the help!! Sascha

Good evening everyone, I am a complete new starter, studying Filemaker and a 980 page book for almost 2 weeks. Please excuse this probably "less in two minutes answer to my question" question: As part of a contact management database, I have created tables company, contacts (people), adresses, telephone, and email. Now I want to create a layout based on company, which displays a full list of company records in a portal. Next to the portal all fields in the company table should be displayed, with all related telephone and email addresses (shown in seperate portals in the same layout). An additional portal in the same layout is then displaying all related contacts, again with merge fields next to the portal showing all fields of the contact table and (again as portals) all related telephone numbers, email and addresses. Accomplishment so far: To display all companies in a layout, I have created a cartesian (X) occurrence between company and company as a self join, to display all company names in a portal. In the company table I have created a calculation field, which also acts as a button, to retrieve the clicked KeyID, and to highlight the clicked row. And here are my problems: Although is works in the Script Debugger, the KeyID is not retrieved, and the selected row of data is not highlighted. Again, when running it through the debugger, it clearly shows that the correct KeyID is retrieved (and the clicked row is highlighted with a the graphic in the container field of the button). Next problem, the related company details, are not changing, although the KeyID changes in the debugger. It seems that they "stick" to the layout. Question: How should I set up the relationship overall? The cartesian related table is used for the company listing in the layout "companies", the tables contacts, address, telephone and email are related with equi joins to companies and contacts Can any of you please give a good advice? many thanks! Sascha