storing information from 2 tables into one.

[PapaWhiskey]

I am quite new to Access, and I am trying to create a db for work - I'm getting most of it without problems, however I just got to a point where I am stuck.
The db I am creating is a directory system that has a rather large table for patron data (i.e. P.O. Box #, Last name, First Name ect.) and another large table with publications information listed (Magazine name, and return addresses) What I am trying to do is create a 3rd table that will store Patron's Box Number, Patron's Full Name, Publication Name, and two dates - one date stored in the patron data file of the date notified, and one in the 3rd table of discard date (which is 60 days after the notified date)

So far, I am spinning my wheels on where to start. Any help would be greatly appericiated.


V/R

Pw

 

[boblarson]

Well, for one, I would suggest you read on data normalization. It is clear from your post that you do not understand (nor possibly even are aware of) this fundamental issue of relational databases. This is VERY important to understand as it helps eliminate redundant data and ensure data integrity.

See here for a tutorial on normalization:
http://www.accessmvp.com/strive4peace/Access_Basics_Crystal_080113_Chapter_03.pdf
With that being said, you do not want to store the details more than once. You only store an ID number (Primary Key as Foreign Key) in the 3rd table. You then use QUERIES to pull the data together when you need to display it for forms or reports.

 

[tranchemontaigne]

once your data is normalized, you can use a "Make Table" query to build your 3rd table
________
EAGLE TALON

 

[boblarson]

once your data is normalized, you can use a "Make Table" query to build your 3rd table

And normally, you don't need to keep making a new table, but you make it once, then can delete the data and append new. That will keep the database bloat down considerably compared to replacing the table each time using a make table query.