Multi Step Form DB relatioships

[neomuckel]

Hello,

i tried to create a multistep contract form.
the first site is for the customer contact, the second site is the contract location and the third site is to choose the service.
i have a table for the customer, location, products and contract.

Table Customer:
Customer : Customer
Customer_id : text
Product : List of Products
status : text

Table Location:
adress : geo adress
customer : Customer
notice : text

Table Product:
Category : Category
longtext : text
name : text
position: number
price : number

Table Contract:
Customer : Customer
contract_id : number
product : list of products
status : text

how can i build the workflow so that i can fill out the form an have all fields with the right connection ?

[emir.ozgun]

First of all , when you call table_contract you extract every values , so don’t have product:list_of_products inside it . You have to have a table of products inside it there should be list of products . That way when you call table contract only 1 unique id will get called

Table Contract:
Customer : Customer
contract_id : number
product : products
status : text

table products
each_product : list_of_products

[neomuckel]

I tried, but i cant choose anything in the dropdown to get the product informations.

Bubble Editor - Heizungsapp

[emir.ozgun]

You have to setup like this step 1) create products > step 2)create table_contract product = result of step1

[neomuckel]

i cant choose the ionic checkbox ,its impossible to add the products to a list for the contract