October 12, 201213 yr My db is set up with contacts info also shown with other portals to tables for address, phone, email, web, notes, etc. Each table has a contacts foreign key and all contacts_"other-table" relationships work Now I want to create lists for the tables and I can't figure out how to show the contact name in those table's lists. For example, with the address table I've tried: address_Contacts contacts_Address_RelatedFilter but neither results in showing the contact name in the address table. This should be so simple - what am I missing?
October 12, 201213 yr I think you're going to have to try explaining your question again - I can't follow it at all. It seems to imply that we are familiar with the database you are working on, which I am not. Are you trying to display the name of a contact on a related table? What is "those table's lists" you are talking about? Value lists?
October 12, 201213 yr Author Apologies. Let me try again: Primary layout is first, last, company name and category options. This layout also contains portals to other tables: address, phone, email, web, notes. I also have list layouts for all these tables individually. My issue comes when trying to display the contact name on the ancillary tables. So, while I managed to set up working relationships with the portals on the primary - Contacts - layout, I've been unsuccessful setting up a working relationship which shows the Contacts name in any of the list layouts for address, phone, email, web, notes Is this clearer? If not, I will try to explain again in a better way - I'm totally right brained and apologize if my logic is convoluted to those who find working in database structures more intuitive.
October 13, 201213 yr Yes, that was clearer. In the Layout Setup window, check the table occurrence selected in the "Show records from" box. Then, go into Manage Database > Relationships and see what tables are related to the one selected (do this for each of your "other" tables). They need to be related to your Contacts table.
Create an account or sign in to comment