> > i can't make ralations from Oracle tables using visigenic odbc driver and fox tables. > > I can't see the oracle indexes... Hi You can't see indexes in VFP using SQLTABLES(), this command get you only tables in oracle and how do you want to set the relation. You can't use oracle index in VFP views. If you want index on downloaded view, you had to create index after view is created in VFP session. Creating indexes on remote view will degrade the performance of application. Feel free to contact me for any questions. Waheed email:mbws@batelco.com.bh .