auto-population of a field based on entry in separate field

[spudracer]

I might have asked this before, but couldn't find anything to support this.

I've got a table which (for tracking purposes) has 4 columns for when a report is due to each office, based on its due date. I can manage the fields on the form to automatically update based on the due date. However, when it comes to updating the table, those fields remain blank.

How can I set it so that the fields will automatically populate on the form, and translate back to the table for queries and reports?

 

[HiTechCoach]

It is considered "Best Practice" for Data Normalization to NOT store calculated values. You calculate them as needed.

 

[spudracer]

Ok, thanks!

 

[Atomic Shrimp]

(As long as the means to calculate them is known to be persistent)

So if, say, a set of milestone dates were set by the decision of a project manager, it might be necessary to store them.

But if the completion date is always X days after the start date, then it can be calculated whenever it is required.

 

[spudracer]

To keep things simple, I simply placed a calculation field next to each box that requires a date. So the form will calculate the date, but it's up to the user to input it so that the it will be stored in the table. Redundant, yes, but simple.

 

[odesaccil]

Hi all, I am a new member of forum