Table Maintenance - Keyfields

[Former Member]

Dear Friends,

i have a table maintenance view with link three tables together.

so i want to arrange fields according to the requirement like follows

field1table1-[key field]

field2table1-[key field]

field3table2-[key field]

field4table3-[non key field]

field5table2-[key field]

field6table3-[non key field]

in this case can't generate maintenance screen, because of all key fields are not in the top of the view.

so please tell me how can i solve this issue.

hope you will clear my issue.

Thank in advance.

[lijisusan_mathews]

Y don't you give it the the order

field1table1-key field

field2table1-key field

field3table2-key field

field5table2-key field

field4table3-non key field

field6table3-non key field

... Then you should be able to create the screen.. If you still want to change the order, after the screen has been created, take the screen that is created, goto Layout and then manually just drag the field in the required order... I think this should solve your problem.Please tell if it dosnt.

Suzie