I'm trying something new in a database that automatically compiles documents through relationships.

What I already have got is a database that compiles lists of items from a another database based on a relationship, resulting in something like:

[item 1 from other database]

[item 2 from other database]

[item 3 from other database]

I've been doing this for some time and it works flawlessly. Now however i want to add a bit of information at the end of each originating from the datase i'm working in. Like this:

[item 1 from other db][addition from current db]

[item 2 from other db][addition from current db]

[item 3 from other db][addition from current db]

However I keep looking at the problem, it seems like i just keep running into a brick wall. Does anyone know how to solve the puzzle?

Thanks, Peter

The problem is difficult i guess.

I hope someone will still be able to help solve the problem.

Thanks Peter

It may help someone to answer your question if you provide more detail about this.

Is the other database a separate file? (You are using FM version 6?) What is/are the relationship(s) between the files? How is the list/report compiled in your present file?

Is it possible to post a very stripped down copy of your files so that the specific situation can be seen?