Hello everyone
I'm a beginner andI need to know how to design my database.
These are my tables.
My questions:
1) Do I need now to join the two tables (create relations)? If yes. Which fields should I join? ID-ID or ID-StudentID?
2) What is the appropriate querries for inserting and retrieving data from the two tables?
3) Do I need one querry or two querries under save button since I have two tables?
I'm using adodc
Thank you all
I'm a beginner andI need to know how to design my database.
These are my tables.
My questions:
1) Do I need now to join the two tables (create relations)? If yes. Which fields should I join? ID-ID or ID-StudentID?
2) What is the appropriate querries for inserting and retrieving data from the two tables?
3) Do I need one querry or two querries under save button since I have two tables?
I'm using adodc
Thank you all