createNew record macro

[sammers101]

I have a Product table for cards, each card has a foil version and a regular version, so I'd like to automatically create an entry for the foil product.

I was trying to run a macro (CreateNew) in the after insert section of my Products table. CreateNew would create a new (almost duplicate) product. That would cause a loop so I would need it to only run once.

Heres what I have entered in the after insert section of my Products table:
If Products.Type="regular" then
RunDataMacro
Macro Name: Products.CreateNew
Parameters
Card = "test"
Rarity = "U"
color = "white"


and Products.CreateNew is:
Create Record In: Products
setField: Products.ProductName
value = [Card]
setField: Products.ProductCode
value = [Rarity]
setField: Products.Color
value = [Color]
setField: Products.Type
value = "Foil"

when I insert a product no error pops up, but createNew doesn't seem to have run
Thanks for any help

 

[SOS]

It wouldn't go in the After Insert event. Use the After Update event and use a DCount to check to see if the record already exists.