Using a calculation to show related data?

[ibiubu]

Two related databases, each with a related field called "ID." Database 1 has 5 records containing a field called "First Name."

From within Database 2 if I type in the same "ID Number" is there a way to have a field that will then contain all the "First Name" matching data from Database 1 (I know how to accomplish this with a portal, can it be done through a single field with a calculation)? I just need a field in Database 2 to contain all 5 matching "First Name" from Database 1. I don't necessarily need to view this data, I just need a field to contain all 5 names because I will be using another calculation field in Database 2 that will rely on this info.

LR

[ April 07, 2002, 01:26 AM: Message edited by: Larry Ross ]

[Steven H. Blackwell]

One of the Troi plugins at http://www.troi.com has a sumtext fucntion that will do this I believe.

HTH

Old Advance Man

[djgogi]

If use of script is not an problem, than simply execute this one:

code:

---

go to related record [your relationship, show only related]

//this part should be an script in related DB

go to layout [OneFieldLayout]

copy all records

paste [your field, select]

go to field [ ]

OneFieldLayout should be an layout with only your name field on it.

HTH

Dj

[BobWeaver]

You can set up a valuelist in database 2 based on the relationship to use values from the First Name field in database 1. Then in database 2 use a calculated field with this formula:

ValulistItems("ThisFileName","ValulistName")

using the actual file name and valuelist name.

Note that you don't have to use the valuelist anywhere else except in this formula.

[djgogi]

quote:

---

Originally posted by BobWeaver:

You can set up a valuelist in database 2 based on the relationship to use values from the First Name field in database 1. Then in database 2 use a calculated field with this formula:

ValulistItems("ThisFileName","ValulistName")

using the actual file name and valuelist name.

Note that you don't have to use the valuelist anywhere else except in this formula.

---

Right Bob

And I have use this, I don't know how many time . So my brain must got stucked.

Dj

[ April 08, 2002, 01:26 AM: Message edited by: dj ]