I am trying to set up a way to both have a books table link with invoice line items and consignment line items.
It is saying the attached.
Invoice line items and consignment line items are two separate tables.
Books is it's own table.
It's fine if I use Books 2 or 3 as it suggests but then when you set up a portal in books to consigmnet forms for example.. or invoices you don't see the data.
Why is this not letting me add another link? When in other scenarios for example my price lists and sales reports tables I have been able to link from artwork? I'll include a larger view of my relationships...