Subject Re: how to place an index on this form From Ken Mayer <dbase@nospam.goldenstag.net> Date Fri, 18 Sep 2020 13:35:36 -0700 Newsgroups dbase.getting-started On 9/18/2020 11:34 AM, agostinho wrote: > Dear group see this form bellow, it's a very simple one. > I'm trying to place an index (INDEXNAME="KCODE" on the form to make it work. > I got the alias database.dbf option on the INSPECTOR  but I don't see any option for index option. > If this is not possible from the inspector than how/where on the form him self. It helps if you learn to use the data objects in dBASE, that way you have the control you're looking for. Where exactly are you opening the table? It's not being opened by the form itself. Are you doing it in a program? If so, in the program you need to add the index: use tablename order kcode Then call the form, and it should be indexed. If you use the data objects, you have to place a query object on the form, the simplest way is, in the Form Designer, go to the navigator, click on the tables tab, and drag the table to the form. Then you could set the index using the rowset's indexName property ... I really suggest that if you're going to use current versions of dBASE you consider the (free) tutorial in my link signature block below ... Ken -- *Ken Mayer* Ken's dBASE Page: http://www.goldenstag.net/dbase The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm