putting related records into one field

[bonitashar]

The most important function of my database is to email travel plans. I have created a field that contains all the information from one record. It worked fine until I had connecting flights and more than one airline.

Now I've created a related file containing each flight as a separate record. Now how do I get each of those records into one field or at least how do I email those records.

Also, I'll eventually have 2 other databases containing more than one record for each travel plan. I need to email all related info for each travel plan.

[Vaughan]

In the master database, create a conditional value list based on the relationship. Then create an unstored calculated field with the following calc:

ValueListItems(Status(CurrentFileName), "value list name")

This will make a list of all the related values, separated by paragraph marks. You can easily use the Substitute() function to replace these with commas and spaces if you prefer.