beginer for table relationship

[art05]

I am builiding a database that has artists and customers and artowork sold
and mailing list tables. Sometimes the artists are customers and buy
artwork. I am going to give a primary key for the artists and one for the
customers. But how do I get the customer-artists on the customer list .
Do I use a subform/ subdatasheet/or child data sheet. What am I looking for?
Thanks- appreciate any advice.

 

[Allen Browne]

Put both the artists and the customers into one table of clients.

Anyone can be an artist.
Anyone can be a customer.
Anyone can be on a mailing list.