 |
|
| Computers Forum Index » Computer - Databases - Filemaker » Information from different records... |
|
Page 1 of 1 |
|
| Author |
Message |
| Jokin... |
 Posted: Tue Oct 06, 2009 5:08 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 |
|
|
|
| Your Name... |
| Posted: Wed Oct 07, 2009 9:27 am |
|
|
|
Guest
|
"Jokin" <joaquin.castilla at (no spam) gmail.com> wrote in message
news:39af34c2-7125-43c4-aec1-5bbfc3a8a5b5 at (no spam) j19g2000vbp.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?
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  ) |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Mon Dec 07, 2009 8:59 am
|
|