Type of Querie that set the same ID to a group of items?

[andrebmsilva]

Hello,

I've tried a lot of options and so far i couldn't do what i need:


Note: Instead of "Action" I meant "Update"

I'm confused if I sholud use an Update Query or an Append Query...
Should i follow this explanation "Update the data in one table by using data from another table" ?

Thanks in advance,
André

[orange]

Sound like you should have 3 tables

Orders
Baskets
OrderInBasket or BasketContainsOrders (your choice -- this is a junction table)


similar to Student and Courses (analogy)

Students
Courses
StudentEnrolledInCourses

Consider

Students - 1 Tim, 2 Jim, 3 Jill, 4 Jane
Courses - 1 math, 2 Chemistry, 3 Science, 4 Physics, 5 Music

Tim takes Chemistry and Physics
Jim takes Math, Physics and Music
Jill takes Math and music
Jane doesn't take any courses

So StudentEnrolledInCourses where each enrollment record gets an Id 1,2,3 etc.

1,1,2 Tim Chemistry
2,1,4 Tim, Physics
3,2,1 Jim Math
4,2,4 Jim Physics
5,2,5 Jim Music
6,3,1 Jill Math
7,3,5 Jill Music
no records for Jane since she is not enrolled in any courses


There is a free video tutorial on Junction table at
http://www.youtube.com/watch?v=7XstSSyG8fw