Recording multiple dates in table.

[bill1one]

I am working on a database that helps me orgainze and keep track of magazine subscritptions. I need to keep track of the date I recieved an issue and when it was discarded. I also need to somehow keep a history for my records, this way I can return to the list to see if a subscritpion was not sent.

Does anyone have any ideas of how the tables structured to make this work. Particularly, how can I track each issue and date for ~100 magazine titles?

Thanks

 

[GingerR]

How do you have your table(s) structured so far? Maybe I'm missing something, but is it as easy as having date fields?

I envision something like this:

Table: Subscriptions
Field: SubscriptionID (Autonumber)
Field: SubscriptionTitle (text)

Table: SubscriptionIssues
Field: SubscriptionID (Number, from table above)
Field: IssueReceived (Date)
Field: IssueDiscarded (Date)

One-to-Many relationship between Subscriptions and SubscriptionIssues.

Is that what you have?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244