Mandatory field in table

[Former Member]

I have created a table with three fields, the requirement is to make it mandatory for the user to fill values in all the three fields for any entry in the table.

I want steps to do this. Detail description.

[Former Member]

HI,

make those 3 fields as primary keys...

it will work i think..

[Former Member]

No its not working with that arrangement

[Former Member]

Hi,

cant u do it with a program...

what exactly is ur requirement.????

[naveen_inuganti2]

Hi.. Adnan...

Create TMG for your table and goto screen painter of that screen, make the all fields as input required....

Steps for your requirement..

1. Create One table with three fields.
2. Create Table maintainance genarator for that.
3. Now Open screen, to create entreis(utilities - > create entries- > view).
4. There system -> status -> program name and screen name.
5. Go to SE80 -> enter above program name for program object
6. expand screens
7. Find your screen number (above) and double click on it & and enter into layout of that screen.
8. In edit mode... click on field column -> attribute -> program tab -> input -> select 'required' from drop down.
9. save , activate.

Thanks,

Naveen.I

[Former Member]

In SE11 open you table and in the FIELDS tab

Check the third column which is "Initial values"

This is NOT NULL column and once checked the fields wont be allowed to ne NULL..

I hope this solves you doubt

[Former Member]

In SE11 open your table and mark the checkbox "Initial values" against the FIELDS that are mandatory according to your requirement .

I am sure this would satisfy your requirement ..

Regards ,

Ashish