Re: Multiple tables refer to one -To use foreign keys or not?

Adriano Varoli Piazza <moranar_at_gmail.com> wrote:

>We have an "attachments" table, which can refer to "works_of_art",
>"people", "reproductions" (Let's say, more than three tables). So a
>work of art can have attachments, a person can have a different
>attachment, etc.

What is an attachment? I can understand the works of art, people and reproductions but I don't know what you mean by attachment.

Tony

-- 
Tony Toews, Microsoft Access MVP
   Please respond only in the newsgroups so that others can 
read the entire thread of messages.
   Microsoft Access Links, Hints, Tips & Accounting Systems at 
http://www.granite.ab.ca/accsmstr.htm
   Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/