Trying to be to clever
Trying to be to clever
I have created a
ToDo form and have two other forms, let's call them
A and
B. Todo's can be either general or specific to either A or B.
So what I did was create a subform, first in the
A form and then another in the
B form. Went to the
Todo view added a look field to the
A form and another lookup field to
B form.
No problems with the on the
A side but there's something wrong with the
B form.
On the
B form when I click "Update" i get a spinning icon and "please wait" but this never goes away. I get the same problem when I add a new row. I've stripped out the subform and the lookup field (on the Todo form back to
B). But the spinning "please wait" is still there. So I can't get back to where I started???
Now I planning to export all the data from form B. Delete B rebuild it and re-import.
Did I upset the SQL in someway by trying to create a many-to-one twice on the "many" side of the relationship?
Thanks to anyone, in advance, that can put me straight.
Peter De Campi