Advanced options greyed out in SQL data source

I want to use a details view and SQL datasource to create a form for entering and editing information in an SQL table.
I have the page working in read only form. But I am unable to set Insert, update and delete options because the items on the advanced tab are greyed out.
I have the primary key from the table selected, but still no good. Suggestions would be appreciated.
davnhmAsked:
Who is Participating?
 
QPRCommented:
have you named the primary key in your select rather than "select *"
0
 
davnhmAuthor Commented:
Yes. I have tried it both ways. I have also tried it with different tables, and still it is greyed out.
0
 
QPRCommented:
Dry setting the data key in the DVs properties window
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.