Forum Discussion
Relationship Issues
Hi! I have an issue with something that appears logical and shouldn't happen: I have 3 tables - Purchase orders with amounts per vendor, invoices paid with amounts per vendor. the issue is , firs...
Hi afedianine
Rather than create a joiner table, which sounds like a solution more for a many-to-many relationship, perhaps join your invoices table to your Purchase order table. If your Purchase order table keeps a unique Vendor ID column then this is probably a better structure.
Or in your existing on, make sure one of the relationships is set to Both (not recommended unless you understand the problem you are trying to solve)
Does that help?