What are you trying to accomplish with the new relationship. What does the edit relationship dialog box look like?
thanks, actually the popover is working now (i needed to add the serial numbers to the existing contacts). However, the struggle I am having is getting this new relationship to work in a portal in clients. This is needed to show what artworks are consigned from (or made by) the client. I have existing relationships which work fine to show what a client has purchased (from invoices) and what a client has consigned from my inventory (consignment forms). I want to add a new portal which shows artworks made by the client. That way a gallery can easily see what they have on loan from an artist, and maybe total up the value they have etc. I'll include my relationship graph to give you the picture. thanks!
The issue being.. if I have a portal to artwork in the client section it shows artworks which the client has bought in invoices.. I need a way to link artwork and clients but in a new way (or different way) to show what artworks which under their name in artworks.
It should work as follows. When a user enters a new artwork, they click a popover in the artwork layout to clients and select the artist name. They click it and it enters into the field which shows who an artwork is by. This is working fine (I have a calculation from clients which links first and last name and it is entering fine with the above script into the artwork layout).
What I need is a portal in clients which shows the artworks a client has made. I have tried having a portal to clients 2 in clients with a field inside listing the title of artworks but that doesn't work properly..
Trying this as the latest but my portal in clients to "Artwork for Client 2" still just lists work purchased in invoices.. I need to work out how to make those separate things. Help...
I have tried other ways of linking clients and artworks and managed to get the portal to list works as they are entered in artworks but they all go into the first client record. Even if they are under a different name in artworks.
It's pretty confusing to me. But I'm relatively new at it. Another thing you could try (which is almost a total rework), is to check out Selector/Connector. I watched it, understand it (sort of), but could not explain it or implement it yet. I know this isn't the quick answer/fix you're looking for.
here's the video
Thanks, frustrating as this is rule 101 of all this. Working so far going one way (to artwork) but not back (to clients).
I might post again to see if someone else can look.
I would just bump the thread and not repost. I'm sure Phil may take a crack at it...when he's not working.....helping everyone...squashing spammers....:)