By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,820 Members | 1,103 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,820 IT Pros & Developers. It's quick & easy.

Searching for the right word to encompass 'Supplier' and 'Consumer'

P: n/a
Viz:

Suppliers ===>DataHub===>Consumers

Seems pretty obvious that Suppliers and Consumers need to live in the
same table - especially since the same entity can occupy both roles.

But what to call the table?

tblConsumersSuppliers doesn't do much for me and Roget's didn't help.

Can anybody think of a concise term that encapsulates both concepts?

Shorter is better.
Fewer syllables is better.
Widely-used/understood is the brass ring....
Nov 12 '05 #1
Share this Question
Share on Google+
9 Replies

P: n/a
PeteCresswell previously wrote:
Viz:

Suppliers ===>DataHub===>Consumers

Seems pretty obvious that Suppliers and Consumers need to live in the
same table - especially since the same entity can occupy both roles.

But what to call the table?

tblConsumersSuppliers doesn't do much for me and Roget's didn't help.

Can anybody think of a concise term that encapsulates both concepts?

Shorter is better.
Fewer syllables is better.
Widely-used/understood is the brass ring....

Bugbears?

It's the politest one I could think of.

Peter Russell
Nov 12 '05 #2

P: n/a
Go**********@FatBelly.com (PeteCresswell) wrote in message news:<74**************************@posting.google. com>...
Viz:

Suppliers ===>DataHub===>Consumers

Seems pretty obvious that Suppliers and Consumers need to live in the
same table - especially since the same entity can occupy both roles.

But what to call the table?

tblConsumersSuppliers doesn't do much for me and Roget's didn't help.

Can anybody think of a concise term that encapsulates both concepts?

Shorter is better.
Fewer syllables is better.
Widely-used/understood is the brass ring....


How about tblVendorBuyer? Or maybe tblSupplyLink?
Nov 12 '05 #3

P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

How 'bout SalesEntities, or just Entities?

SalesEntities means you can sell TO them and also be SOLD TO by them.
Kind of a stretch....

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP+JruoechKqOuFEgEQKDLwCg6d9ojDyVTjT+I50EeoomcT B6/Q8An063
XQOGSpNMkuiCtcLYZ2wGUg8p
=hqYk
-----END PGP SIGNATURE-----

PeteCresswell wrote:
Viz:

Suppliers ===>DataHub===>Consumers

Seems pretty obvious that Suppliers and Consumers need to live in the
same table - especially since the same entity can occupy both roles.

But what to call the table?

tblConsumersSuppliers doesn't do much for me and Roget's didn't help.

Can anybody think of a concise term that encapsulates both concepts?

Shorter is better.
Fewer syllables is better.
Widely-used/understood is the brass ring....


Nov 12 '05 #4

P: n/a
I use tblBusiness, with a tblBusinessType, tblContact, tblStatus

Go**********@FatBelly.com (PeteCresswell) wrote in message news:<74**************************@posting.google. com>...
Viz:

Suppliers ===>DataHub===>Consumers

Seems pretty obvious that Suppliers and Consumers need to live in the
same table - especially since the same entity can occupy both roles.

But what to call the table?

tblConsumersSuppliers doesn't do much for me and Roget's didn't help.

Can anybody think of a concise term that encapsulates both concepts?

Shorter is better.
Fewer syllables is better.
Widely-used/understood is the brass ring....

Nov 12 '05 #5

P: n/a
On 18 Dec 2003 09:36:49 -0800, Go**********@FatBelly.com
(PeteCresswell) wrote:
Suppliers ===>DataHub===>Consumers

Seems pretty obvious that Suppliers and Consumers need to live in the
same table - especially since the same entity can occupy both roles.

But what to call the table?


"Parties"? Because suppliers and consumers can participate in many
other types of relationships, too.

--
Mike Sherrill
Information Management Systems
Nov 12 '05 #6

P: n/a
On 19 Dec 2003 04:43:34 -0800, le*********@natpro.com (Roger) wrote:
I use tblBusiness, with a tblBusinessType, tblContact, tblStatus


In the general case, not all consumers are businesses.

--
Mike Sherrill
Information Management Systems
Nov 12 '05 #7

P: n/a
RE/
I use tblBusiness, with a tblBusinessType, tblContact, tblStatus


In the general case, not all consumers are businesses.


I'm going with tblOrganization or tblOrg...
--
PeteCresswell
Nov 12 '05 #8

P: n/a
On Fri, 19 Dec 2003 20:52:24 GMT, "(Pete Cresswell)" <x@y.z> wrote:
In the general case, not all consumers are businesses.


I'm going with tblOrganization or tblOrg...


That might work in your specific case. The point I was making--and
not very well, I'm afraid--is that in general, some consumers of
products and services are individuals, not organizations or
businesses.

--
Mike Sherrill
Information Management Systems
Nov 12 '05 #9

P: n/a

tblConSup
Go**********@FatBelly.com (PeteCresswell) wrote:
Viz:

Suppliers ===>DataHub===>Consumers

Seems pretty obvious that Suppliers and Consumers need to live in the
same table - especially since the same entity can occupy both roles.

But what to call the table?

tblConsumersSuppliers doesn't do much for me and Roget's didn't help.

Can anybody think of a concise term that encapsulates both concepts?

Shorter is better.
Fewer syllables is better.
Widely-used/understood is the brass ring....


Nov 12 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.