Ok,
I have a table publication which has PublicationID, PublisherID, NameAbbrev... and this is joined to another table called AreaBuy which has an AreaBuyID field, NameAbbrev, DateCreated and CreatedBy fields. The relationship is basically that the company has signed up a group of papers (not necessarily owned by the same umbrella company) for our products. The publication and AreaBuy tables are connection via a PublicationAreaBuy table which has a 1...M...1 relationship (ingenious names right!). I have a table publication which has Publ
