The only solution I know of is to use a view with the appropriate information. Create the necessary index tags in the Load event of the form. Set the icMainAlias to the view and you should be good.
Check out VMDECTY1.SCX for an example of using a view icMainAlias. The only difference being you will also be setting up sort behaivior with SetIndexTagInfo. If you have any other questions, post them here or onthe VMP site.
>I am using VMP 5.0.
>I have a form based on FrmDeGrdnav2Pages that edits invoices.
>I have a comany and an invoice table.
>I would like to put the invoices in the navigational
>grid on page 1. I want the user to be able to navigate the
>invoices by company name or invoice number and utilize
>the re-sorting features on invoice number or vendor name +
>invoice number. But since the invoice table references the
>vendor table with just a foreign key (ven_FK), this poses all
>kinds of problems. What is the best approach to solve this problem.
>These are all local vfp tables. I tried having a view as the main
>recordsource for grdNav but that is so frought with problems that
>I haven't got it working yet. There has to be a simple solution
>to this problem. Any ideas?
>
>- Paul
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao