Changing from renewal to CC SQL error

Tom Bilan ( )
Fri, 27 Jun 1997 17:36:34 -0400

Emerald 2.1.11

When I change a user from renewal to CC and I type in all the
credit card info AND click auto-bill then hit save it gives an
SQL error. I cut and paste the SQL statement into ISQL/w and
it gives the following error:

Msg 547, Level 16, State 2
UPDATE statement conflicted with COLUMN FOREIGN KEY constraint
'FK__MasterAcc__PayMe__7829DFE5'. The conflict occurred in database
'Emerald', table 'PayMethods', column 'PayMethod'
Command has been aborted.

When I enter in all the CC info but DON'T select auto-bill then save,
go back and select auto-bill and then hit save again, it works.

Also, when I go back into the billing tab I can't see the credit card
the person used. The masteraccounts database has the correct card in there
but the dropdown tab isn't being updated, it's just left blank.