Hi,

Is there any way to have a field containing the data from other fields
(in the same database file) from records which have something in
common.
For example:
I have a file that contain three fields: A, B and C.
I want to have a new field D which contains the information that is
contained in C WHEN A and B are more than 10 (for example).
So, if I have three records:

A is 11, B is 11 and C is "Home"
A is 9, B is 9 and C is "Car"
A is 12, B is 12 and C is "Garage"

I would like to have a field D that is "Home" and "Garage".

Is this possible?

Thanks,
Jokin

"Jokin" <joaquin.castilla (AT) gmail (DOT) com> wrote

It's definitely possible, but the best way to achieve it will depend on
whether this new field D is to be displayed on-screen when browsing records
or is only going to be used for printed / previewed reports. Also if it
actually needs to be a new field at all or perhaps just a Portal displaying
related field data.

Helpfull Harry )