One Form - Multiple Entries to same table

[pdoucette]

Been searching for an answer but haven't quite found it. I am creating a DB that tracks Goals & Objectives for students. One goal may have multiple (2-5) Objectives. I have a form where I am able to create and assign the a goal and 1 objective to a client.

...basically i need a form that creates multiple entries into my table for however many objectives they have...all other info on the form is static

Form:

Student: Paul
Goal: Lose Weight
Objective: Exercise 1 Hour a day
Objective: Stay Under 20 Carbs a day
Objective: Eat 3 Cups of Vegetables a day
Start Date: 10/29/18




Desired Table Outcome:

Student Goal Objective Start Date
Paul Lose Weight Exercise 1 Hour a day 10/29/18
Paul Lose Weight Stay under 20 carbs a day 10/29/18
Paul Lose Weight Eat 3 cups of vegetables a day 10/29/18

Let me know if I need to clarify anything, kind of new to this

Paul

 

[plog]

Before we make your form work, we need to concentrate on the data. Can you set up the Relationship tool in Access, link your tables appropriately, expand the tables so we can see all fields, then post a screenshot of it here?

I fear you haven't set your tables up properly and that needs to be addressed before you tackle forms.

 

[pdoucette]

Sure thing, here it is

 

[pdoucette]

Should have clarified, I have already created a form that works for entering 1 goal with 1 objective. Was hoping to be able to enter multiple objectives on that form and have the repeated data auto fill in the table.

 

[plog]

Looks good actually (well, there's no need for the GoalLookup table, but that's minor). There is a 1 to many relationship between Students and Objectives, the way you accomplish this with forms is with a form/subform table (https://support.office.com/en-us/ar...any-form-ddf3822f-8aba-49cb-831a-1e74d6f5f06b).

The link above provides in-depth specifics--here's the broad strokes: You should create a form based on StudentTable (StudentForm) that displays just one record. You then create a continous form based on CurrentGoals (ObjectiveForm). You add the ObjectiveForm to the StudentForm as a subform, linking them via Student ID fields.

With that a user can input as many objectives as they want per student--jsut keep filling out new lines in the sub-table.

 

[pdoucette]

I have the goal lookup to limit the types of goals they can enter...these are fairly set in stone. The objectives however are completely different for each student, would be entered into text boxes...I will give this a shot.

 

[mike60smart]

Hi

You need a separate table linked to your Current Goals in order to enter Multiple Objectives for the Goal entered.

As Plog has mentioned this would be achieved by using a Subform to your Current Goals Form