S
s_hah
we use ms office professional access 2003
we have 1 table contain : class no. and limit of student and another table
contain : class no. and number of seat for student
example : FORM # 1... table 1 : class no. Limit of
student
A34
3
CD12
1
how can we generate append record from table 1 into table 2
depend of limit of student ?
SUBFORM .. Table 2 Record # Seat # class no.
student name
1 1
A34
2 2
A34
3 3
A34
4 1
CD12
Please help us.
Thank you very much
we have 1 table contain : class no. and limit of student and another table
contain : class no. and number of seat for student
example : FORM # 1... table 1 : class no. Limit of
student
A34
3
CD12
1
how can we generate append record from table 1 into table 2
depend of limit of student ?
SUBFORM .. Table 2 Record # Seat # class no.
student name
1 1
A34
2 2
A34
3 3
A34
4 1
CD12
Please help us.
Thank you very much