Simplifying the question
A re run of DA Wizard using the menu options (using the lightning bolt to choose the different tables) for the categories works well. I now have insert and update pages with menus of 3 categories that are populating the database properly. I just can't see how to get the details page to show the correct labels (Cat IDs are right). I've tried adding the tables to the existing recordset. I've tried adding new recordsets copying how they work on update and insert pages. I've tried adding dynamic text from different per page. Just need the method to display the same result as the insert and update pages on the details page (albeit not as a menu)