Importing OBCD data to just current (New) Record

[jtflex]

I have my Audio Log Database connected and working through an ODBC connection to our larger records database.

My goal is that when a user creates a new record of their digital audio file, they can connect to the records database and import most of the data they need for entry.

Everything works pretty well. However, one issue I have is that I want the imported data to only update the current(New Record) the user is creating. When I run it, the matching field (I'm using "Report_No.") Finds all the previous enteries of this "Report_No.", updates and displays them all.

How do I limit the update to just the current record entry is being done on?

I'm using FM 6, on a PC

Everybody been a great help with me so far and this project and I appreciate all the responses.

Joe

 

[jtflex]

Sorry,

I just figured out a solution. In my script, I performed a find on the serial number I created for each record first. Then on the import command, I selected to only update current found records set.

If theres a better way do let me know though,

Thanks,

Joe

I'm sure I be asking more questions in the future though.