Hi, I have two tables, one has two fields:
student ID and student name
its kind of like this:
1 Mark
2 Tom
3 Franklin
the other table has three fields: student name, student classes, it goes like this:
Mark calculus
Mark Biology
Tom Statistics
Franklin Calculus
Tom Chemistry
what I want is for the second table to have its related id from the first table so it could be like this:
1 calculus
1 biology
2 statistics
3 calculus
2 chemistry
Is this possible ?
I cant simply make find and replace because the records are a lot is there another way should I relate the tables of something how will it work?