I´m still a beginner but I´ve made some progress now thanks to some of you in this forum. My central form linked to a question which is linked to a many to many table seems to function in certain aspects now. But it is still not ready for use.
One problem is when I write new info in the central form I can see the effect in the many to many table. The records are dependent on a combination of foreign-ID´s. An example a specific lake, a specific species and a specific method gave a special result.
But when I will change the result for that combination of foreign keys. I don´t manage to do it. Instead I get a new record for the same combination of lake-species-method with the changed result in the many to many table. So then I have two results for the same combination of keys!! No good!!
I can´t even show the old result with the right combination when I put in the right names of the specific combination in my form. How to do to show the result which I´ve already had put into the table?? Can I use the same central form for that??
One problem is when I write new info in the central form I can see the effect in the many to many table. The records are dependent on a combination of foreign-ID´s. An example a specific lake, a specific species and a specific method gave a special result.
But when I will change the result for that combination of foreign keys. I don´t manage to do it. Instead I get a new record for the same combination of lake-species-method with the changed result in the many to many table. So then I have two results for the same combination of keys!! No good!!
I can´t even show the old result with the right combination when I put in the right names of the specific combination in my form. How to do to show the result which I´ve already had put into the table?? Can I use the same central form for that??
