What relationship shows contact name in 2nd table?

[jrob]

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?

[dansmith65]

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?

[jrob]

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.

[dansmith65]

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.

[jrob]

Thanks, so simple when you know the answer!