added association processing and NULL processing