[comp.databases] dBASE help

atieu@skat.usc.edu (Anthony Tieu) (04/13/90)

I have two data bases relate by an id number


   customer		equipment

1. id			1. id
2. name			2. equip serial no.
3. address		3. equip code no.
4. city			4. .....
5. ...

I can use the following dbase code to print out all equipment belonging
to each customer.

	SELECT 2
        USE equipment INDEX id
        SELECT 1
        USE customer INDEX name
        SET RELATION TO id INTO equipment
        
The list will be in order of equipment entered. I want to print them
in order of equipment serial no. How can I do that without checking
the entire equipment database?
______________________________________________________________________________

campus: University of Southern California  |     "Black Velvet"
        Alumni House                       |           --Alannah Myles