There are two joined tables...
STudent and Parent
Lets say in the student table I have columns for StudentName, StudentAGE
and in the parent table I have columns for ParentName, ParentAge etc
In "add new form" can I get data entry fields for two different tables.
The ADD NEW FORM should have...
StudentName
StudentAge
ParentName
ParentAge
When I enter data for the fields the data should be entered to two different tables.
I understand that the tables should be joined. Buy my question is how to dispaly the fields in the Add new page?