beginer for table relationship

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top