>Jane, assuming that you have the table2.integerField in Table3 as a foreign key, your index would be str(tagle3.integerfield+dtos(table3.DateField). If you DON'T have the table2.integerField in Table3, how are you planning to link the child records in Table3 with their parents in Table2?
>
>Barbara
The table2 interfield is in table 3 but table 2 has the integer field that's in table 1. I want to index on a table1 value. Can I say index on str(table1.id) + DTOS(table3.date)? What I'm trying to do is avoid dups in table 3 - the dups are based on a table 1 field & a table 3 field. Perhaps I have to do this another way. Would a view help? I'm not certain I'm making myself clear. I've done this in a DOS app but I don't have integer primary keys in DOS. In DOS, the actual fields are repeated so it is easy to do. Even though I have an integer primary key that relates the tables, is it a big no-no to have the name of the field as well? Than the indexing and dup-checking is easy.

Thanks