Hi I am trying to link two collections (available items and Pricing Menu). The available items can be rented/or leased by the hour, day, week, month, etc. I have a form built that captures all of the data and creates a new record in the Available Items collection, but I can’t seem to get the relationship right so that a user can choose to rent out the item by the hour, day, etc. Any thoughts or help would be appreciated!
I have tried creating the relation ship from both collections and have tried all three options but really it needs to be many to many as available items can have any of the pricing types and the pricing types can belong to any available item. When I insert the action to create the new Available item the “Pricing Type” field for the new record isn’t available?