Import into multiple tables?

[NickFaraday]

I am not sure if I am going about this the right way or not. have a main table, then two associated tables that are made up of uniqe parts of the main table...

For exampel I have Shipping Table, Boxs Table, and Items Table.

My import is of Shipping Table.

Box, Item, Other Data

I also have Box Table and Item Table. I want to imporot my Shipping Table then check to make sure Box number is in the Box table and Item is in the item table.

All in one import script.

Or should I even have the Box and Item Table? and try and pull one instance of each 'box', 'Item' out of the import? As they are there anyway?

Edited October 18, 2006 by Guest

[John Mark Osborne]

Could you explain the purpose of the entities (Shipping, Boxs and Items) of your solution so we can help determine if you have a good relational design? Also, where are you importing from? Why do you need to check if the box number is there?

[NickFaraday]

Boxs/Items are just an example...

Real world:

Tables:

Camera Rolls

Images

Image List

I get an Image List from another dept. comma del,

It has Camera Roll, and Image Name along with other data. I Import that into Image List.

I need to be able to Look up Images by Camera Roll(What images are in this roll?), and Images List by the Image. (What List are this image in?)

I will be make a few other many-to-many relationships based on Camera Roll and Image Tables. The problem I have is I need to build these tables as I import Image List.

I can do this manually by importing(update/add) just camera roll column to the camera roll table, and image column to the image table, but I am looking for a way to do it all in one import script.

Or if my DB structure is way off I can change that as well.

Edited October 18, 2006 by Guest

[John Mark Osborne]

It sounds like one Camera Roll can have many Images and one Image can have many Image Lists? If you want me to verify your relational structure, I need to know the answer to this question.

Regardless of your structure, it's pretty clear you need at least two tables. Do the Camera Rolls, Images and Image Lists come in separate comma-separated files?