importing one record at the time to....

[pinkabou]

Hello every body, tx in advance to your help

source .txt file with some field (#tape, number of gig, date of backup)

filemaker file : filemaker database with some field (#tape, number of gig, date backup, expiration date) . The filemaker database countain many record with the same #tape, to see the "life of the tape", so when I perform a find on the #tape, I found many record, sort in descending order on expiration date, so the last record I see, tell me if the tape was recycle or not(if not recycle the expiration date is empty)

i would like to be able to perfom this task

selct a .txt file for import

If not cancel

read ONE record from the source

if record read

loop

find in the FM database if these record are find(base on #tape)

if the result return NO record

continu

else

show the result in descending order expiration date

end if

ask if i want to ADD a record for tape #tape

if YES

add the record with the info and put in date of day the today date

else

show message with " Take the number -#tape- in note to resolve conflict

end if

read ONE record from the source

continu until the last record of the source file is reach

endi if

in the filemaker database, find all record where date of day is today

print

stop

[-Queue-]

I do not believe it is possible to import a single record at a time. However, you could use another fp5 file to temporarily hold all the imported records, then loop through it, pulling the data into your original file one record at a time, as desired.