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