I am creating a training record database, I have made the tables but need to work on the user interface.
What I am struggling with is I can have a lesson which is created with an author lesson title, lesson description and supporting documents and also lots of lesson objectives so I have one lessonID with multiple lesson objectives linked to it.
How can I create a form where I can write in the unique lesson details and then have multiple lesson objectives from say a drop down box link to another table.
Thank you