Mobile Number Flow

Hi,

I am new to bubble and trying to build an application

Database Structure:
Table 1 - Has the customer database along with mobile number
Table 2 - Tracks Orders made by the customer

What I am trying to do ?
User registered with unique mobile number
To book order, user enters the registered mobile number and clicks on Submit
Based on the registered mobile number, the customer details to be picked in order booking screen

Kindly help how to pick up the customer data based on the mobile number

Many thanks

Orders table [incase you are storing the mobile number on order table]
search the users/customers search mobile number = Current order’ mobile number
It will return the exact customer details.

Otherwise. on submitting the mobile number on order page, add new field in the Order table names as “Customer” and before submit save the customer data with “Search the Customer search mobile number = text field value” and save it. It will return the order details along with customer details.

Thank you. I will give it a try and let you know. Thank you for the response. Appreciate it.