link view to table in data environment

[LenaS]

I created a view of my 'ledger' table called 'unsettled'. I did this as an alternative to filtering the ledger table in the data environment which was incredibly slow. How do I link this view to my 'contract' table? The view doesn't seem to allow indexes. I need to link the table to the view by a string of 4 fields.

 

[DEDMOD]

One thing you might do is add a field to your contract table based on everything except the view and then create an index on this new field. --Dave

 

[LenaS]

I'm sorry, but I don't understand.

 

[ramani]

I suggest you create a multi table view containing the ledger and contracts tables fields, instead of the current ledger only view. This could solve your problem.
ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com