Database joining tables

I have a table of user with name , last name and company name as field
then i have a company table with company name and other info as field
in one page i am creating a user including the company name
in another page i am creating a company, my question is how can i connect the two table to have for a user just one company and viceversa
So far I created a user and a company with company name as common column but when i try to call any company info for a specific user in a simple page I am not able to do it

Thanks in advance for your time

Hey there! :wave:

You can actually attach the company you created to your current user very easily. Create a data field under your User Type called Company and instead of TEXT, choose your COMPANY Data Type. Then when you save the Company info you can attach it to your user and access his Company information.

Does that help? Or need me to set up an example for you?

Hope that helps! :blush:

if you don’t mind an example would be great thanks:))

No problem, give me a few minutes. :blush:

thanks:)

Ok here you go:

Preview: https://805testapp42.bubbleapps.io/version-test/joining_tables?debug_mode=true

Editor: https://bubble.io/page?type=page&name=joining_tables&id=805testapp42&tab=tabs-1

Hope that helps! :blush:

@j805 www.NoCodeMinute.com

For All Your No-Code Education Needs:

  • One-on-One Tutoring
  • eLearning Hub
  • Video Tutorials
  • No-Code Classes
1 Like

amazing thanks a lot :)))

1 Like

No problem! :blush:

This topic was automatically closed after 70 days. New replies are no longer allowed.