Hi, I appreciate the help in advance. I'm new to Access, so I apologize if this is a basic question but it's something I couldn't figure out.
I have a form with a subform. It's a recipe database. The form contains all the relevent information for a recipe except ingredients.
i put ingredients into another table and display as a subform in datasheet view.
The issue arises when I input the ingredients, only the last item is displayed in the record. If I unlink the subform and main form, they show up, but the ingredients show on the next record of the main form.
I hope this makes sense. I want it so that when I input a record in the main form, and input ingredients into the sub form, the ingredients show up per record, and are blank when i go on to a new record.
Can anyone help?
I have a form with a subform. It's a recipe database. The form contains all the relevent information for a recipe except ingredients.
i put ingredients into another table and display as a subform in datasheet view.
The issue arises when I input the ingredients, only the last item is displayed in the record. If I unlink the subform and main form, they show up, but the ingredients show on the next record of the main form.
I hope this makes sense. I want it so that when I input a record in the main form, and input ingredients into the sub form, the ingredients show up per record, and are blank when i go on to a new record.
Can anyone help?