I have a table BOOK which is child to CUSTOMER.
Book: Customer ID_FK
Every CUSTOMER has to give me accountant book every month. I make a new record for each year for every customer and I have boxes for every month. When I get the book, i put an "x" in the field of the corresponding month.
I have a layout which is a list grouped by year so it is very useful for me, when I want to make an update. I removed a field "year" from the body, because it is already in grouping part.
Problem: when I want to add a new record I can't, because I don't have place to describe year. Is there any way to add a new record using a new window?