Values not appearing in table

YoMate

Registered User.
Local time
Today, 10:10
Joined
Feb 27, 2005
Messages
13
Hey PPL...hows life???

i need some help here.... One of my forms has an age text box which is linked to a module ... so however, it calculates the age......

But the age is not shown in the table.... I need it to do that....

But i dont know which code to use... I heard of the INSERT INTO function
but dont know how to use it and under which event to put it....

my textbox in the form is named Age and the table is TblPatientDetails???

Please i need to do this urgently...

Thanx
 
YoMate said:
But the age is not shown in the table.... I need it to do that....

If you have the date of birth, which you must have to calculate the age, then you NEVER need to store the age. Storing a caluculated value, in this case 'age' goes against the Third Normal Form (3NF) of database design, namely that you should eliminate non-key dependencies.

If you want the age you can calculate it at any time with a query or an expression on a form or report.

I'd suggest doing some reading on database normalisation to understand actual database design concepts.
 

Users who are viewing this thread

Back
Top Bottom