my relationship is :    one salesman   to    many clients
But what about stock
I must use stock also in my database :)

any suggestions?

salesman to client is obviously one to many, as you say because one salesman
usually has many clients. That's the easy one. Stock is more difficult because
whose stock is it? Is it the client's? or the salesman's?

Suppose it's the salesman's stock. Does each salesman have his own stock items,
or is there an overlap between salesmen and stock? That would mean it could me
one to many, or many to many. The same if it's the client's stock.

Or is it stock that the salesman wants to sell to the client? In which case you
would have to relate salesman to stock to client, and have either one to many
or many to many relationships (as per above paragraph).

The other thing to consider is how is the data going to be used. Usually in
situations like this, there is another table called "Orders" or something like
that. The client places an order, and each order has a salesman. In this
situation there is many to many relationships and one to one relationships
going on.

Have fun.

Ditto salesman and clients:  they are Things.

"Ownership" is a Relationship; in this case a Many-to-Many
relationship.  Relationships (note: I am =not= using the specialized
MS-Access meaning of the term! ! !) imply the existence of more tables
whose only purpose is to describe them.

For example, a piece of stock is a piece of stock whether it's owned or
not.  (A database needs to be able to describe it, owned or not.)  A
second table might link Customers with Stock.  And so on.

James & Carla Buss wrote: