AnsweredAssumed Answered

Create new records

Question asked by paulscholz on Jan 14, 2018
Latest reply on Jan 16, 2018 by philmodjunk

I have a join table that I want to create new records for each record that contains a specific value in one field and does not contain a specific value in a different field. I’m trying to do this in a script from a button.

ID(Auto)

WOID

TestID

Specification

Status

1

1

1

Complete

2

1

2

Failed

3

1

3

Awaiting

4

2

2

 

So, I want to create the new records.

ID(Auto)

WOID

TestID

Specification

Status

1

1

1

Complete

2

1

2

Failed

3

1

3

Awaiting

4

2

2

5

1

2

6

1

3

 

Create new records where WOID = 1 and Status not= Complete.

Outcomes