Forum Academy Marketplace Showcase Pricing Features

How to use lists to replace my foreign key

Hi,

I’ve stumbled across bubble and think it’s great however I’m struggling with lists and how to make my normal primary and foreign key relationships.

Im trying to build a basic app for creating a quote and assigning it to a customer. The customers quote would contain many work types that contain subtasks which that can be added like a list.

The basic structure for a relational db would be this

Quote
quoteid - primary key
customerid -foreign key
type of work
description
price

Customer
customerid - primary key
customer details

Can someone help me with the work flows please. I’d really appreciate it.

I’ve been through the session for lists but it doesn’t seem to quite map to my needs since im not creating a lists for the logged in user.

1 Like

Hi. I’ve the same issue.
Did you solve this?

Hi, how did you solve this?