Market App

[111128]

Dear sir

I built app sheet consist of multi tables,

1st table for markets

2nd table for items of markets

3rd table for orders

4th table for order details

2nd table connected to 1st table (ref ) market id

3rd table references to 2nd table (market id)

4th table referenced to items table and referenced to order table

How i can select items based on market

[MultiTech]

Hello @111128

First, welcome to the community! You might check out the following post, it’s got a ton of helpful tips to help you get started.

Guide on How To Create a Community Post Tips & Tricks 💡

Excellent guidance from a senior guide in the community @LeventK. My humble suggestions below: Over the years the AppSheet team and community members have created some excellent reference material. I believe many interesting solutions and excellent help articles and sample apps are available. Whenever a new member joins the community, we anyway get a notification from the community platform. While responding to the first few posts of a new member, we, who have been around in the communit…

In regards to your question: You should check out dependent dropdowns; since you’re already utilizing references this will become much easier.

help.appsheet.com

Dependent Dropdown

How to make a dropdown with choices that depend on the value selected in another dropdown.

help.appsheet.com

Dropdown on a Ref Column

How to limit which values appear in your dropdown when updating a Ref column.

help.appsheet.com

Conditional Expressions

How to use expressions so that behavior depends on a set of conditions.