 |
|
| Computers Forum Index » Computer - Databases - Filemaker » Information from different records... |
|
Page 1 of 1 |
|
| Author |
Message |
| Jokin... |
 Posted: Tue Oct 06, 2009 9:21 am |
|
|
|
Guest
|
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 |
|
|
| Back to top |
|
|
|
| Remi-Noel Menegaux... |
| Posted: Tue Oct 06, 2009 4:02 pm |
|
|
|
Guest
|
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 (no spam) gmail.com> a écrit dans le message de
news:c9d12517-79be-4cca-a2fa-772871c898a9 at (no spam) m20g2000vbp.googlegroups.com...
Quote: 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 |
|
|
| Back to top |
|
|
|
| Howard Schlossberg... |
| Posted: Tue Oct 06, 2009 9:20 pm |
|
|
|
Guest
|
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:
Quote: 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". |
|
|
| Back to top |
|
|
|
| Bill... |
| Posted: Wed Oct 07, 2009 4:14 am |
|
|
|
Guest
|
In article <hafu9k$qil$1 at (no spam) news.motzarella.org>,
Howard Schlossberg <howard at (no spam) nospam.fmprosolutions.com> wrote:
Quote: 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:
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".
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. |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Sun Nov 29, 2009 8:29 pm
|
|