Export Current Record Only

[Alpha-Snail]

Is there a way to export the current record ONLY? I need to be able to export one record so that I can import it back in to another application.

If anyone knows of a way, do you know if your solution work on a runtime application?

Please help.

[QuinTech]

Hi, Alpha. Only the currently found records are exported at any time. This goes for runtimes, too.

You can narrow down your found set to the currently displayed record through a combination of finds and omits, either manually or by a script.

J

[Lee Smith]

Hi Alpha-Snail, and welcome to the Forum,

To add to what Jerry just said, you can do this manually,

While viewing the record to be exported:

Go to the Menu >> Records >> Show All Records

Go to the Menu >> Records >> Omit Record

Go to the Menu >> Records >> Show Omitted Records

Export your record.

Or

If this is another FileMaker File in the same Version (i.e. 3/4, 5/6, 7) you could just import it directly into your other file.

HTH

Lee

[Alpha-Snail]

Thanks for your reply.

I've thought of that, but I'm not sure how to do it in an automated environment. Ideally, my clients should be able to click one button to make it happen. ...I tried creating a new "test" field that would lookup the current index, so that no matter what record I was in, that field would equal the current index value, but so far I can't get it to work.

This is perplexing!

I appreciate any help anyone can give.

[Alpha-Snail]

Sorry Lee,

It's going to another application.

Also, it has to be a script since it is being executed in a runtime environment by other users.

What about creating a field that does a lookup of the serial index number? That way, every time the current record changes, the looked up value would as well. Should be able to do that somehow, but though I've been trying, I can't quite figure it out.

Would you (or anyone else) know how to do this?

[Lee Smith]

Hi Ron,

I started to reply to this when it dawn on me that I might not be understanding your question.

Is this what you mean?

You have users with Runtimes of a solution.

They create a record and then need to export for use elsewhere.

They only need to deal with the Current Record

You want them to click a button in their runtime, that will select the current record, and export it

Is this close? Please add any steps I missed, or delete any that are not correct.

HTH

Lee

[Fenton]

There is an easier way in FileMaker 7. Open a New Window. Then do the Show All, Omit, Show Omitted Only. Exports happen from the current layout and window, each of which has its own found set.

Or, alternatively use a self-relationship with a unique serial ID. Go To Related Record, with New Window, Show only related. (You could rename the window also, if there's a chance it could get left open, and you want to be sure and close the right one.)

When you're done, Close Window ( current window ). You should Freeze Window as the 1st step. Not really needed, but makes it "snappy."