Hey guys/gals, n00b here with just a quick question. I currently have 3 tables and wondering if having two of tables linking to the same primary key of one table a problem. Then have a form just seperate the two. Here's a quick example
Student Info table
SSN
Name
Address
Attendance
SSN
Date
Course
Payment
SSN
Paid
So if I have Attendance and Payment's SSN link to Student Info's SSN, I shouldn't have any problems right? And just create forms for Attendance and Payment.
Student Info table
SSN
Name
Address
Attendance
SSN
Date
Course
Payment
SSN
Paid
So if I have Attendance and Payment's SSN link to Student Info's SSN, I shouldn't have any problems right? And just create forms for Attendance and Payment.
