[DUG]: SQL Update question

[Steve Galyer]

I have a Client table and a Card table, each client can have any number of cards, what I am attempting to achieve is to update a field in the Client table called CardIssuedTotal with the count of the cards associated with that client.   I am using the following SQL statements, however I am getting an error "Parameter CARD.CardNumber has no default value"   UPDATE CLIENT SET CLIENT.CardIssuedTotal = (SELECT COUNT(CARD.CardNumber) FROM CARD GROUP BY CARD.ClientNumber) WHERE (CLIENT.ClientNumber = CARD.ClientNumber); Any assistance appreciated.   Steve Galyer