Import data and making updates to them

[just2cool]

Hi, I need some help with the following problem. Thanks in advance!

I have imported an Excel spreadsheet into Access database. I will need to constantly add new entries to the tables. I need to connect all my tables together, the main table is called "Data". From looking at Access examples, I believer there should be many other table IDs inside this table (so that they all get a relationship). I imported 5 tables, and each one is dependent of each other. I do not know how to connect the tables together because I'm importing all the data, instead of creating new tables and putting the table IDs into one main table to start off with. I know if I start off without needing to import any data, this will not be difficult to do.
The main "Data" has about 30 fields, and the user will only need to type in 15 fields and the rest of the fields can be looked up from the other four tables. So I'm not sure how I can make the connection between all the tables, plus when I need to add new entries to one of the tables, how do I connect the tables so that all of them will be connected?
I've tried using queries and having queries within queries and this takes forever to load. If there is a way that I can limit the use of queries or just use tables to do the job that would be great.
Thanks again!

 

[Dennisk]

Essentially your main table has to have a Primary Key and this is used in the other tables as a Foreign key. So what you are looking for is a way to link them all together. Is there a common key you can use. If you use an autonumber that is generated at the time of the Import you will need another key to link the Main and sub tables so that you can update the foreign key.

Post your data structures and an example of the data.