Adding data for the next 11 months

[Guest]

I have a form to which employees add , delete or update locations (addresses
) each month for 12 months for each customer. There is a main form with the
basic customer information for each month and a sub form with all the
locations for each month. A location must be on each month unless it is
removed. (Customer A is a new customer as of June and has 3 locations. In
July, he has June's 3 locations and has added 4 more. In August, 1 of June's
locations is deleted.) I want to (1) in June to create entries for the next
11 months with the 3 locations (2) when I open July see the June records (3)
add the 4 new locations to the upcoming months (4) when the location is
removed in August it must be removed from the upcoming months BUT still be
listed in June and July. If changes are made in August it must update the
upcoming months but not the previous months.

I hope this is not too confusing.

 

[pietlinden]

I have a form to which employees add , delete or update locations (addresses
) each month for 12 months for each customer. There is a main form with the
basic customer information for each month and a sub form with all the
locations for each month. A location must be on each month unless it is
removed. (Customer A is a new customer as of June and has 3 locations. In
July, he has June's 3 locations and has added 4 more. In August, 1 of June's
locations is deleted.) I want to (1) in June to create entries for the next
11 months with the 3 locations (2) when I open July see the June records (3)
add the 4 new locations to the upcoming months (4) when the location is
removed in August it must be removed from the upcoming months BUT still be
listed in June and July. If changes are made in August it must update the
upcoming months but not the previous months.

I hope this is not too confusing.

Yes, at least for my feeble mind, it is confusing. Part of the
problem is that you are describing a FORM in your post, but no TABLES
(where the data actually resides). Without that information, it's
hard to understand (without guessing) where the data actually resides.
Creating entries for 11 months is trivial. If you had a table of the
numbers from 1 to 12, you could create a deliberate cartesian product
and limit records with a comparison and then append the result of the
cartesian join to a table.

But what, in business terms, are you trying to accomplish?

 

[Guest]

It is not that confusing, but it is a bad practice to create records you may
or may not use in the future. If it is necessary to auto generate records
for monthly information, you should create the records when you need them.