Regarding the Date

[slkamath]

Dear All,

I have 3 tables called Input, Daily Production, Preventive Maintenance.

In INPUT TABLE FIELDS ARE MENTIONED BELOW:
IP_PRTNUMBER - PART NUMBER,
IP_PRTNAME - PART NAME,
IP_CAVITY - CAVITY,
IP_CYCTM - CYCLE TIME,
IP_QTY - QUANTITY,
IP_PLAN_DTFM - PLAN DATE FROM,
IP_PLAN_DTTO - PLAN DATE TO,
IP_PLAN_MNTH - PLAN MONTH,
IP_MCNUM - MACHINE NUMBER

Here I want to know if I entered the PLAN DATE FROM field I need to get PLAN DATE TO (date) automatically. So how to give the formula and where do I need to give that?

The formula is mentioned below
=((([IP_QTY]/(79200/[IP_CYCTM])*[IP_CAVITY]))+[IP_PLAN_DTFM])

Please help me in this regard.

Thanks in Advance

Regards

Lokesh Kamath

[NTC]

in database design; if your field is always calculated, and that formula will never change - - then there is no need to record the value in a table: in which case you would have an unbound field on your form - and in its properties for source you would put:
=((([IP_QTY]/(79200/[IP_CYCTM])*[IP_CAVITY]))+[IP_PLAN_DTFM])

and this value will display 'on the fly' whenever the form is opened.


but if you do need to actually record the value - and are therefore only automating the humans data input - then you will have a bound field (let's call 'DateTo'). In which case one generally puts the action in the AfterUpdate event of which ever field will be used by the human to put in the last of the critically needed information. And so in that event you put:

Me.DateTo=((([IP_QTY]/(79200/[IP_CYCTM])*[IP_CAVITY]))+[IP_PLAN_DTFM])

hope this helps.