Control Data in Tables

[flaviojr]

HI, I'm my name is Flavio and I'm from Brazil and I start in this forum in order to help me in the learning of Visual Basic and Mysql because I need to make a program for a school and I'm founding some difficulties to accomplish the task alone, this reason I ask for the permission of the members of this forum to authorize my person to participate. Thanks for the attention.

I have a dial-up connection for this reason I'm taking the opportunity to post.

I have four tables : tb_Group , tb_week , tb_time , tb_room and another table where I control these fours.

What I need to do is this: Every week I need to change groups and rooms in a School for example.
every group must be in a diferent room from the previous week, And I need to make a historic of weeks to know where the groups had have their classes on the previous weeks for it I'm using one table (td_week)
with a 5 weeks and one current week to control the historic.

the current week
8:00AM, group1, room2, teacher1
8:00AM, group2, room3, teacher4
9:00AM, group3, room3, teacher1
10:00AM, group4, room1, teacher2
...
....

the Historic
1st week , group 1 time 8:00AM, room 1 , teacher 1
1st week , group 1 time 8:00AM, room 2 , teacher 2
1st week , group 1 time 9:00AM, room 3, teacher 4
1st week , group 1 time 10:00AM, room 4, teacher 5
2nd week , group 1 time 8:00AM, room 5, teacher 7
2nd week , group 1 time 8:00AM, room 6, teacher 9
....


and I can't repeat the room in the next week for the group.

Thanks in advance for the help. Any help will be useful
I'm need to solve this

[Hack]

Welcome to the forums.

What code have you written so far that isn't working for you?