table design

  • Thread starter Thread starter mvalrie
  • Start date Start date
M

mvalrie

I need to setup tables. Here is the problem. I work in the
newspaper industry. One publication date can have many
inserts associated with that date. The inserts can have
the same name but different publication dates. How can i
set tables to sort for specific dates and the inserts
associated with that date ?
 
What are the fields in your table now? Sorry...your question is so simple, I
must be missing something.
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Com.Piersontech@Dreamboat
(Reverse it!)
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
 
mvalrie, let me take a stab at an answer, given what you've posted. You want
two tables, tblPublicationDates and tblInserts. Their structure might go
like this:

tblPublicationDates - holds publication dates
DateID [Primary key] - AutoNumber
PublicationDate - Date/time. Default Value: Date()

tblInserts - holds inserts information
InsertID [Primary key] - AutoNumber
DateID (or PublicationDate) [foreign key (from tblPublicationDates)] -
ties the two tables together
InsertName - Text. Name of insert
Other fields as required.

Create a query that includes both tables. Sort on Publication Date and you
will get all inserts associated with that date. Filter on publication date
and you will get *only* the inserts assoc wi/that date.
 
I need to setup tables. Here is the problem. I work in the
newspaper industry. One publication date can have many
inserts associated with that date. The inserts can have
the same name but different publication dates. How can i
set tables to sort for specific dates and the inserts
associated with that date ?
Click to expand...

You need a third table, related one-to-many to both the Issues table
and the Inserts table. See the thread just posted here entitled
"Many-to-Many Resolver/Junction tables" for a good discussion.
 
Back
Top