If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
splitting tables w an update or append query
first, is it possible?
i have a set of tables that i need to take the data and split it into tabels that store the same information with out redundancy. the problem goes like this. i have 5 machines in a country, each in a different city, each is of a model that may be the same, each with parts that make up the entire machine. currently all the data is in 5 excel tables which i can import easily or link to the database i want to create. each part used to make an individual machine can be slightly different from a machine of the same model. for instance the wheel on one machine might be different from the wheels on another. so i need to list both of these parts. but yet the machine is the same. i have created all the tables i want the data to go into, but i need to put data into multiple tables. for instance i have a parts list table and a unit list table. i need to take all the part data and put it into the table for it, but at the same time i need the query to match that to the data listing the individual machines. is there a way to do this? i love update queries, but those will only add the data to one table at a time. if i need to explain it more please let me know. |
#2
|
|||
|
|||
splitting tables w an update or append query
check out the book "the access developer's handbook". It's a great book and
has a good chapter on splitting and normalizing tables. "DawnTreader" wrote in message ... first, is it possible? i have a set of tables that i need to take the data and split it into tabels that store the same information with out redundancy. the problem goes like this. i have 5 machines in a country, each in a different city, each is of a model that may be the same, each with parts that make up the entire machine. currently all the data is in 5 excel tables which i can import easily or link to the database i want to create. each part used to make an individual machine can be slightly different from a machine of the same model. for instance the wheel on one machine might be different from the wheels on another. so i need to list both of these parts. but yet the machine is the same. i have created all the tables i want the data to go into, but i need to put data into multiple tables. for instance i have a parts list table and a unit list table. i need to take all the part data and put it into the table for it, but at the same time i need the query to match that to the data listing the individual machines. is there a way to do this? i love update queries, but those will only add the data to one table at a time. if i need to explain it more please let me know. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
creteria macros | sierralightfoot | Running & Setting Up Queries | 13 | March 8th, 2006 06:13 AM |
append query?? Or Update query?? or Both?? or None?? | Minal Shah | Running & Setting Up Queries | 1 | February 3rd, 2006 04:09 PM |
Help with append query for one-to-many relationship tables | Vika | Running & Setting Up Queries | 1 | September 17th, 2005 08:29 AM |
update queries and forms | Mary Pode | Database Design | 16 | February 2nd, 2005 05:25 PM |
Taher | Setting Up & Running Reports | 1 | August 31st, 2004 09:07 PM |