Storing additional data with a connection

(0) Share

Report

Posted on by Community Member Microsoft Employee

In our industry and line of business we sell to both Vendors and Retailers. It is possible for a Retail to be a direct customer of ours and receiving our product through a vendor. What I would like to store additional info with certain types of connections without having to create intersection tables. Here's a simplified example where I'd like to store the RelationshipId that a vendor assigned a retailer. Is this something that is possible or am I going to be forced into creating an intersect table?

FromAccount	Vendor	ToAccount	Retailer	RelationshipId
1	Napkins R Us	50	McDonald's	NRU-115
1	Napkins R Us	40	Wendy's	NRU-912
1	Napkins R Us	34	Taco Bell	NRU-491
2	Sporks 'n Things	50	McDonald's	AA132
2	Sporks 'n Things	40	Wendy's	D9913