Jump to content

FM Sorting Problems


SASanders

This topic is 8491 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 8491 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.