Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

A Couple of Basic Export-to-Excel Questions


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

Recommended Posts

Posted

Howdy, all:

My FM library is lacking in explaining exporting FM records to Excel in sufficient detail to make it easy for the novice, so I need a little guidance; I've personally never used Excel, but I've been dabbling with the '07 version of it today on a friend's PC.

My questions are:

1) Is there a script "trick" to exporting related records in FM? I tried a number of different permutations with a simple export script and only once did it show the Parent's table related records; the other times I ran the same script it didn't export them so I can't reproduce what I did. *blush*

2) In the one instance where the related records were successfully exported, the Parent table's data only appeared in the first record on the same line (record) as its related fields--the other corresponding fields were blank.

Shouldn't the data in the PF fields be duplicated for each related record during the export? If they're not and someone performs a sort in Excel, then there's no way to determine which record the "blanked" RF-only fields belong to.

TIA for your help and have a great '08!

Cheers,

Rich

This topic is 6172 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.