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

Yes, of course, you can create a relationship of a file with itself : it is
called self-relationship.
All you have to do is to set a special link field that would have the same
value when you want it.
I did not study your case in detail to do that for you but I figure you'll
be able to do it yourself.
Please advise if it works.
Of course, 'we' could go further if you need to.
Remi-Noel


"Jokin" <joaquin.castilla (AT) gmail (DOT) com> a écrit dans le message de
news:c9d12517-79be-4cca-a2fa-772871c898a9 (AT) m20g2000vbp (DOT) googlegroups.com...

It sounds to me like A,B and C are all i nthe same data table? If so,
then you just need to create a calculation field for D. No
relationships necessary.

Jokin wrote:

In article <hafu9k$qil$1 (AT) news (DOT) motzarella.org>,
Howard Schlossberg <howard (AT) nospam (DOT) fmprosolutions.com> wrote:

Depends if they are in the same record. if they are in the same record
then Howard is right about a simple calculation with no need for a
self-join.

The way the O. P. wrote it, it sounds like they are in different records
that have something in common. IN that case, you would need a self-join
to do the calculation.