>As generated from the view designer:
>
>SELECT Process.*, Machine.machdesc FROM process!process INNER JOIN maint!machine
> ON Process.machnum = Machine.machnum WHERE Process.partno LIKE ?vparampn
>
>Database maint holds table machine which is giving the trouble.
OK, I think I know what the problem is.
I think it has to do with the index order of the cursors - or the order they were added to the DE.
I tested this - if the view was added first, the form prompts for the database.
If the table (in your case, machine) is added first, it works fine.
This should fix it.
1) Open the databases you need.
2) Modify this form and clear out the DE.
3) Close and save the form. Just a belt-and-suspenders approach.
4) Modify the form.
5) Add the Machine table to the DE first, then add the view.
Insanity: Doing the same thing over and over and expecting different results.