In-Form fields, autofill

[genciT5]

Hello everyone!



I have a problem with a database i am trying to create. Because my english isn't so good, i will try to show you my problem in a different way, in a simple example.

Let's say I am trying to create a access database for an dentist. And I am building a form where he can register his patients.

I want to make things easy for him. So when he registers a new patient, there is a field called "Year Old" (how years old is the patient), and an other field called "Age" [Remember it's just an illustration of my problem]. So what I want is, when he types a value into "Year Old" field, automatically (or by default) the other field will fill either Adult / Minor. So if the 'years old' field's value is under 18, the age's value will be "Minor" , else if it is bigger or equal to 18, age="Adult".

Any suggestion how can i do this?
Thank you

[orange]

Before getting too involved with forms etc, make sure you have a data model that supports your business.
Here is a free data model related to hairdresser appointments. I think you could adapt it to a dentist's practice.
Getting your tables and relationships set up to match your needs is key to database.

These are the business facts related to the business in the model

The model is meant as a starting point and is generic. It may not meet your needs but you can use, alter or drop parts as necessary.

Good luck.