FM Sorting Problems

[SASanders]

I have 2 databases (CustomerDB and JobDB) related to each other.

In my CustomerDB, I have a Portal Window that looks at the JobDB. How can I sort the records in this window by JobDate?

Also, are the records in this portal window printable? When I've tried printing, it only prints out the viewable records - anything that below where the portal window needs scrolling, don't appear.

[BobWeaver]

In the define relationships dialog, you can check the "sort related records" option. Then the records in the portal will be sorted.

Regarding printing, as you have discovered, portals don't print very well. They are really designed more for browsing than printing. Printing directly from the related file allows much more flexibility. If you need to include information from the customerDB, you can create a reverse relationship from the JobDB back to the CustomerDB and then include those related records in a summary part on your layout.