Custom Criteria

Hello!

I'm working on building 2 custom criterion and I need a little assistance. 

Price Type Category: Below is what I have in T_KEYWORD, but received the error: 'Syntax Error in Query: Invalid column name 'customer_no (List Sql). Based on the error, I think this means that my issue is the Detail Table doesn't contain a customer id column. I think what I need to do in this case is create a custom view?

Desc: Price Type Category

Data Type: Number

Edit Mask: Alpha Numeric

Detail Tbl: TR_PRICE_TYPE

Detail Col: !.price_type_category

Ref Tbl: TR_PRICE_TYPE_CATEGORY

Ref Idcol: id

Ref Desccol: description

Primary Group Default: Default Value Number

Unique Production Seasons: What I want is to be able to pull lists of patrons that purchased tickets to more than 1 production each season. I started by copying Ticket History Unique Perfs in T_KEYWORD. This worked successfully without errors, but wanted to confirm I did this correctly. 

Desc: Tkt History Unique Prod Season

Data Type: Number

Edit Mask: Number

Detail Tbl: vs_ticket_history

Detail Col: count(distinct !.prod_season_no)

Thanks!