I have created two tables. With the first Table I can configure the GridView to Insert, Edit and Delete records via the GridView form directly into the table.

With the second table, I can not configure the  ADVANCED SQL GENERATION OPTIONS - I can not activate anything. Both the GENERATE INSERT, UPDATE, and DELETE STATEMENTS and USE OPTIMISTIC CONCURRENCY is greyed out.

The second table have a relation to the first.

What do I need to do in order to also be able to update the second table in the same way as the first table?

Regards
Jan

Hi Mikhail,

Thanks for the reply.

This is just the thing - I have tried it. Whether I select all the fields ("*"), or just some them, I those options still stay greyed-out.

I thought it might have something to do with the fact that the there is a relatationship between one of the fields in the second table and first Table "id"-field. Could it be, or not?

 Regards

Jan

Hi Jan,

Could be off base here, but this did happen to me once--and I realized that I didn't have a Primary Key set on the table I was pulling from.  If there is no PK, then those boxes will be greyed out.

Just a thought.  

CLEE:

Hi Jan,

Could be off base here, but this did happen to me once--and I realized that I didn't have a Primary Key set on the table I was pulling from.  If there is no PK, then those boxes will be greyed out.

Just a thought.  

 

That happened to me too. The table needs to have a primary key as far as I can see for those options to be available.

CLEE:

Hi Jan,

Could be off base here, but this did happen to me once--and I realized that I didn't have a Primary Key set on the table I was pulling from.  If there is no PK, then those boxes will be greyed out.

Just a thought.  

 

That happened to me too. The table needs to have a primary key as far as I can see for those options to be available.

Hi CLEE and Guy0510,

Perfect - problem solved! Thanks for your help!

Regards
Jan

Just thought I would add my 2 cents in on this one.....

I just exprienced the same issue... I have to say thank you to all that responded on this one because it was driving me insane (being a newbie and all)