Hello,

I wonder if anyone can help me with a problem with relationships.

I have 2 tables, clients and contacts, due to clients being able to have multiple contacts, I have a portal on the clients layout where you can enter the contacts. I am now trying to create a list view that shows both the client name and the names of the contacts working there. ideally the client name would show up once with the contact names listed next to it. My solution was to have a client name field on the contacts table that copies the Client name into it when a contact is added. The tables are related via a contact ID and the list layout is based on contacts table via this relationship. This works fine but the problem I have is when a client has no contacts which obviously doesn't show up in the list.

Does anybody know a work around for this? My limited skills are making me pull my hair out

Thanks

James

Is this a Report? or is this used for further navigation? If it's just a report, you can loop the clients and loop associated contacts (if any). Push the information Into a variable and then push the variable into a global field for display.

HTH,

Beverly