Creating multiple Records

[Elkpodemiami]

Hello everyone, I have a problem trying to create multiple parts at once, this is the way i want it to work:

I have a database where i have a field called part number, i have a different layout where i have a global field, so i have a scanner that scans a serial code, does an enter automatically (goes to the next line) and does the same thing until i decide to stop scanning. So i should look like this,

1

2

3

4

5

6

I want to have a button called create that reads all the lines but creates line by line.

I hope somebody has a response for me, i would appreciate...

Thanks in advance

[bcooney]

The goal is to scan and create part records?

But, when does the user enter the part description (or a catalogID)? Batch creating records leaves the record incomplete doesn't it?

Yes, I could describe the technique to parse your global field of serial numbers and loop thru creating part records, but won't the result be part records with serial numbers but no description? Will they all have the same description, catalogID?

[Elkpodemiami]

Thanks for replying, yes, my goal is creating only the parts that're being scanned inside the global field, i already have a database with the description of the product and their own serial numbers, so i'll make a relationship to fill the information depending on the part number that i create.

I just have trouble doing what i said before, making a button that reads all the lines and create line by line as a single product.

[bcooney]

I don't understand. You are creating part records, but already have them?

Anyway, just loop. Set a counter to the count of values in the global, grab the next value using GetValue(global, counter) and create a new part record, decrement counter. Exit loop when the counter equals 0.

[Elkpodemiami]

Sorry bcooney, I think im not following you, i tried looking foe the GetValue in the functions but its not there, maybe FMP 6 doesnt have that function.

i know that the idea is to make a loop, but i have a lot of dificulties going line by line on the same field.

[Vaughan]

No, FMP 6 does not have that function.

*Seriously* reconsider doing any new development work with FMP 6 and earlier. You're developing with obsolete software, learning ways that will have to be un-learned when you change to the newer versions (FMP 7 and later).

[comment]

Try it this way:

Scan.fp5.zip

[Elkpodemiami]

Thanks a lot comment, thats exactly what i was looking for.

Thanks a bunch, cheers!!!

[flyf]

That is great. I have also been searching online for ways to scan in multiple entries also but my problem is a bit different. I have all my data already in 1 table. I want to do a scan that will pull up the "part#" but keep scanning until I get all the "part#'s" that I want. Then I want to copy this "part#" and paste it (along with a preassigned unique serial number) into a new table (this will be the related field now) and assign a person to work on them. Then I would create a button that would transfer all the data into the new table and erase the temp data. I am trying to do this with a portal but having an awful time trying to figure it out. I was trying to use a temp file but I'm pretty new to scripting this advanced. I don't know if that made any sense or not. I can be more specific if you'd like. Any advice I can get would be much appreciated.