first sorry for my english, I'm french but I'll try to be as understandable as possible ;)
I have 3 collections for a website :
-ConstructionsList : for a list of constructions sites that members have registered by a FORM A
-Tools : for a list of tools (with name of tool and category of it)
-PossessedTools : for list of tools possessed by each members
Here is my issue :
I have a form (FORM A) which allow members to create a construction site. The submit button update the ConstructionsList collection for now.
Now I want to add an information in this form, which show the tools list (which are in the Tools collection) and I want to allow members to check the tools they own, in order to add this information in the ConstructionsList collection AND in the PossessedTools collection at the same time.
I want to do that because I want to show in a page which tools are available for a construction site, and another page what tools a member have.
In the Tools collection, I put the ToolName field as primary key and in the PossessedTools collection, I put ToolName field as reference to the same field in Tools collection.
My question is : how can I configure my form to do this? And do I have to add a special field in the ConstructionsList collection (a reference field too? Because there will be several tools available for each constructions site !)?
I'm a beginner in wix code and I don't know which function to add to the form...