Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-29 : 09:31:46
|
Graeme writes "[Microsoft Access]
I have a table with 5 fields;(1,2,3,4,5). Eack row is a specific product code. I also have 5 other related (to each other) tables, each of which have the fields; (ID_No, Letter, Parent). Each of these 5 tables correspond to fields 1,2,3,4,5 in my initial, unrelated table. The productcodes are of the type A/BB/C/D/EEEEEE and this is the construction of each row in the initial, temporary table. I am wanting to update the 5 related tables distinctly, using the data in the temp table. Each 'letter' field has a parent value which is taken from the autonumber ID_No of the parent table, effectively a tree. How do I update these tables in access using SQL. I am desperately floundering in the murky depths of SQL, and would accept any help gratefully.
Windows 2000/ NT4.0" |
|
|
|
|
|
|
|
Using Access. Data from temp table into Relational DB