Hi...

Simple problem (I hope).
FM8.5/MacOS

I have 2-tables, A and B in the same database
I'm in browse mode.
I want to have the ability to have a user hit a button and take
the current record in A and move it into B.
Something like a INSERT..SELECT in RDBs.

For the life of me, can't figure it out.

Any suggestions?

TIA,
Joe

PS: Yes, I know it's not good design, but there are legal reasons why
this needs to be done.
Blame the lawyers.

OK.... assuming you must use that design for legal reasons, and assuming
that Table B has the same field definitions as Table A:

Write a script that does these things:

1. In Table A, narrows down the found set to the record you want to
copy.

2. Goes to a layout that uses Table B.

3. Import records from Table A to Table B, with imported records being
added to the existing records in Table B.

4. Go back to your original layout in Table A.





In article <1165614204.024039.261020 (AT) f1g2000cwa (DOT) googlegroups.com>,
"JoeT" <trubisz (AT) yahoo (DOT) com> wrote:

OK...I'm a bit lost...
I can enter find mode and find records with no problem.
It's the script I'm having problems with.

omit
find omitted

The problem I have is with scriptmaker. 'Find all' isn't a problem and
I assume that I want to add to the script 'omit record' (since there is
no 'omit' by itself). The problem after this is 'find omitted'. That by
itself doesn't exist (fine), so I use Perform Find, use the same key I
used in the Find All (step 1), and select 'Omitted'. Problem is that it
wants something for the Find Requests.

Not sure what it wants here. Then again, I'm not sure if Perform Find
is correct here either.

Joe


Greg Dember wrote:

In Scriptmaker:

Show all Records
Omit Record
Show Omitted Only

You probably just didnt "see" the "Show Omitted Only" in your script
step options.

-- Greg




In article <1165628518.337005.127750 (AT) 16g2000cwy (DOT) googlegroups.com>,
"JoeT" <trubisz (AT) yahoo (DOT) com> wrote:

OK...so far, I've established I had the right idea, but approached the
problem incorrectly.
Newbie error.

However, your first reply indicated that now that I have the record, I
can import it.
OK...the options for import say that I can import from:
File
Folder
Digital Camera
XML Source
ODBC source

I don't have an option to copy from a found set to the current layout.

Is import the correct command I should be using?

Joe


Greg Dember wrote:

You wouldn't be "copying" a found set, you would be importing. Go to
Import > File, and point to the file source (even if it is the same
file). From there you will get an import mapping dialog where you can
set the source and target tables, map your fields and move on.

JoeT wrote:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance