Linking tables

[mama16]

Hello, I'm trying to build this db with data that resides on spreadsheets.

I currently have 4 tables,

"Deployers"

State_ID PK
Population

"Cities"
State_ID
cities

"Statistics"

State_Id
calls per hour


"Quarter"
state_id
ist
2nd
3rd
4th

Is it ok if I link all four tables by state_id, example AZ, CA, FL,?

In deployers state_id will not repeat but in the others it will. For example, Statistics table has stats for each state from 01/2000 to present

 

[lespaul]

That looks like it should work to me

leslie

 

[mama16]

Thank you, thank you thank you, your're the best. I am going to buy the book, A fundamental of relational database design.
Are you always here? Just in case I have another question. I'm working on this database, its due next month.
I have to get the data that resides in an excel spreadsheets and populate the db with it.
Can I always find you here? or do you have an e-mail?

Thank you so much, you helped me out a lot.
appreciate it.

 

[PHV]

When in database window, menu File -> External data -> Import

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mama16]

You mean, the data from the spreadsheets can be transfer to the db. How do I know the data is going towards the right fields that are in the db

thanks,

 

[PHV]

I strongly suggest import the spreadsheet to temporary tables and then play with append queries.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244