>I have a standard invoicing routine that uses an invoice header table linked to an invoice detail table. I have to have the detail table ordered on the tag (invoice_id) that links it to the header. What is the procedure for then ordering the the detail table on a secondary tag (like inventory_num)?
>
>Thanks in advance
>
>John Dennis
John, simply add the inventory_num field to your Invoice_id tag (or, if you need a tag on JUST the ID then add a second tag for both fields together).
HTH
Barbara