Need help to filter the data

[Kenny_M]

Hello,
I’m newbie in Bubble. Pls help me this thing:

• I have 2 data type: Customer, Contact. 1 customer can have many contacts, but 1 contact just belong to 1 customer.
• When i create new customer and select the contacts: i don’t want the dropdown to show the contacts that belong to another customer. Pls help me to do it.

I’m sorry for my bad english.
Thanks!

[aryan2003dikshit]

connect both to user and do current users contacts it will only show their contacts and not the customers contacts.

[Kenny_M]

Hi,
But they are not related to User data type.
User data type is used for my app user (my company user)

[aryan2003dikshit]

Yes i understand that’s why im telling you to make it that way to filter it.

[Kenny_M]

Could you tell me in detail, i couldn’t find out today.

[harry7]

Hey @Kenny_M , not sure if this will work for your scenario but it’s how I’ve got my app setup:
Instead of having a list of contacts field on the customer, have a customer field (not a list) on the contact. So each contact has a customer. This way you can do a search for contacts with a constraint like:
Customer = *newly created customer

[Kenny_M]

Hi Harry7
My problem is solved: I did as you said and combined it with a few steps after watching this video, and this article:

Performance Q&A guide

I’m going to be checking this thread periodically over the next week to answer questions on performance best practices, inspired by (among other people who have asked for this): This will probably get turned into a performance section in the manual, but I figure the forum is a good place to kick things off. I have to run for now but will chime in later today with some general tips + answers to blueback09’s questions above.

Data architecture design in Bubble.is

Thanks!

[harry7]

No worries, glad you got it sorted!