You're right, it sounds more logical to coordinate all the categories in a table and make a relationship between them and each article.
I have now restructured the tables that contain categories into a single category table.
I have also registered a number of articles related to the correct category. This is okay.
On the Update page:
I want each category to be displayed individually, as repeating check-boxes. I just want to show 50 items at a time from each category. Therefore, I have restructured the form so each category is in its own fieldset.
Then I have created a recordset for each category, filtered on category id. This seems to work fine, so far.
When I created the relationship comes the problem. If I understand correctly, I have to create multiple relationships that everyone goes to the same table and field, because I have several recordset.
If I try a relationship that is connected to only one category - it works fine. Data is written into the table and displayed correctly on the Update page. But when I do multiple relationships, it does not.
How can I solve this? Grateful for help!
