Records not saving after updating combo box

[nika.duncan]

Good day,



I created a lunch menu system that I want to save menu for the days of the week. When the record is updated and click "Add Record" the data overwrites the record that is displayed. I need the form to add record and clear form for selection of new information.
Not sure what I am doing wrong but any help will be appreciated.

Please see file attached for any help.

Nika

[davegri]

Here you go. Changed the macro for the save button to go to a new record instead of next record.
Also changed caption of the button from "Save Record" to "New Record". Save is automatic, you don't need a button.
LunchMenuFinal-v2.zip

[pbaldy]

Your add button should go to a new record. It's set to go to the next record.

[nika.duncan]

When I change the add button to go to new record I am unable to add another record. It generate the error "Cannot add recodr(s), join key of table 'Staff Detail' not in recordset and it is the same error when I used the "New Record" button.

Any help will be appreciated.
Nika

[aytee111]

A bit of table notes: do not carry the staff name in more than one table. Use the Staff_UD as the field to store on any other table requiring the staff name. Branch has also been duplicated, this only needs to be stored once in the database.

For your form, the record source should be the table you are adding to - Staff_Detail. Not the query. The staff name on the form will be bound to the StaffUD on the detail table and will contain the StaffUD and the Staff Name and the branch, with the UD not being shown.

[davegri]

Worked on this a bit more, see the results here.
Made wholesale changes to relationships. Using autonumber primary keys and numeric foreign keys for linkage instead of text field keys.
Nika-LunchMenuFinal-v4.zip
Question about branch (which is in 2 tables, a no-no). Can a staff member be in 2 branches? Is a branch related more to where the meal is prepared, or to the staff member?
Question about weeks: Do you want to assign meals for more than one week at a time? Do you want to delete the meal assignments after a given time?

Unless all groups are required when building meals, suggest you add a choice to each food group for each day, "Skip", so that something is available to enter.