I have a portal in my customer file that shows credit card information from another file (CDC Credit Card). I made a script in the credit card file so that when the card expires, the field (status) changes to red (from the repeating field expired), when it is <30 days from the expiration date it turns yellow. This way the person looking up the record (and taking the order) is alerted when the card is going to expire. Script runs great if you run it from the credit card file, but i need for it to run from the Customer file. Tried to run an external script and nothing happens. So I mad a script in the customer file that changes the fields in the Credit card file. I t not only doesn't work, but if the card is expired it takes the red out of the filed. Help! My script looks like this:

If[ (CDC Credit Card::CCexp - Status (CurrentDate)) < 30 and (CDC Credit Card: CCexp - Status(CurrentDate)) > 2]

Set Field [CDC Credit Card::status, GetRepitition( CDC Credit Card::expired 2)]

Else

If[(CCexp - Status(CurrentDate)) < 2]

Set Field [CDC Credit Card::status, GetRepition(CDC Credit Card::expired 3)]

Else

Set Field [CDC Credit Card::status, GetRepition(CDC Credit Card::expired 1)]

End If

End if

It seems like I always have problems with scripts like this being tempermental, so it is all possible that I am making a rediculous mistake, but any help would be greatly appreciated.

It's a glitch with GetRepetition.

Note that with GetRepetition(CDC Credit Card::expired, 1), you don't need the 1. If you are setting the first repetition (or the only repetition) in another field, the name of the field is all you need, since GetRepetition(field, 1) = field.

Thanks for the info. At least I know that there is something else to blame besides my lack of experience with Filemaker. Unfortunately I am using container fields for the colors.

Elizabeth