Thanks for the prompt reply, flugh. I was thinking of doing something like that but had wondered if there might be a more elegant way of achieving this without the additional tables.
While not a major issue, I would need not only a sales2brokers table but also a sales2sellers table (to record...
I am having issues trying to find a way to enforce a constraint for a column that can store multiple values.
What I want to do is create a table that stores Sales. For each record in Sales, the broker(s) would be stored that were involved in the sale. The number of brokers involved could vary...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.