maybe it is still another aspect of the previous question about single form inserting data to multiple collections. i recommend you look at other popular sites that have similar challenge and how they go about it.
maybe think about a single page with the title ‘Dog owner details’ it will allow you to add or edit your details as a dog owner, just below that form you can also display the dogs this person have. maybe a repeater, or a gallery of the dogs etc. just next to that add the capability to edit an existing dog details and an ‘add a new dog’ button which will take you to another page or create another form in the existing page to do that.
i am trying to recommend a way that will first work so you can make a progress with the site and maybe polish that some more in the future
please have a look at this example https://www.wix.com/code/home/video-database
although it is not a category, the ‘grouping’ is the owner person. you might want to think about the challenge this way, just as a first phase
Thank you again for assistance,
but I think the problem here is that, the wixData.query connects on the database1 (regdog), so wixLocation.to ( currentuser ) works only in database1 (regdog).
Is there away to connect two database in one wixData.query?