I have a problem. I have two tables which are as follows
tblFormName
I don't want the user to have to select FormNameID in the main form as that is not a meaningful piece of data.
How do I go about doing this?
tblFormName
- FormNameID (pk)
- FormName
- studentsID
- Surname
- FirstName
- FormNameID (fk)
I don't want the user to have to select FormNameID in the main form as that is not a meaningful piece of data.
How do I go about doing this?