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.
Who is Participating?
have you named the primary key in your select rather than "select *"
davnhmAuthor Commented:
Yes. I have tried it both ways. I have also tried it with different tables, and still it is greyed out.
Dry setting the data key in the DVs properties window
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.