MySQL table Ref won't work!

[Dana_S]

Hello,

I imported 2 tables form MySQL: Orders & OrderDetails
Order table contains generic order information while OrderDetails contains order items, now I want to be able to see item list per order (as ref table) each time I tap on an order but seems my configuration won’t work.

I configured as follow: in table OrderDetails, I changed Type for OrderNo to Ref then selected Orders table hoping this will take care of the task I want as mentioned by an article about referencing in AppSheet.
This creates the reverse record in Orders table but nothing shows on the Orders view, what am I missing?

And is this the only way to achieve what I need? Is there a place where I can add an if statement, like if OrderID(table2)=OrderId(table1) then show?

Best,

[EIG]

I think you just have it backwards. The Ref should be on the Orders table.

[Grant_Stead]

First, I’m having a fascinating issue with REF today. Second, you do have your ref setup correctly. Third, you need to look at your UX views… Make sure you have the associated inline views. Forth, do you have slices?

[Dana_S]

How “associate inline views”?
No slices so far.

[Steve]

help.appsheet.com

Reference Views

A Ref View is a hidden view that is only used when drilling down into your data -- here's how to use them.

[Grant_Stead]

in the Order table is OrderNo tagged as the Key column?

[Dana_S]

No it’s not, and seems I can’t change it, I expect because OrderNo contains some chars (ORD#####), anyway, does it need to be a Key? What if I needed to have more than one Ref with that table? I assume I only can assign one Key per table.

[Steve]

help.appsheet.com

What is a Key?

Learn the purpose of keys and why they’re necessary.

[Grant_Stead]

The key field must be unique.
Other than that when you set the orderno column to key, make sure you uncheck whatever else is identified as key… THEN save and verify

[Steve]

help.appsheet.com

App Design 101

How to think about building your app

[Dana_S]

Thanks Steve for those, I already read most of that except for Key one.
Can you tell what the issue might be in my case? Is it possible it’s related to some other stuff like it’s a new account/free account/Read only…etc?

[Steve]

Dana_S:

Is it possible it’s related to some other stuff like it’s a new account/free account/Read only…etc?

I doubt it. I suspect your data just isn’t properly structured. In order to do what you’re trying to do, you need to understand keys and references.

[Dana_S]

Thanks for your help everyone, I was able to fix it.
First order_no was not Key then I had to change it’s type from LongText to Text to be able to make it Key, seems LongText cannot be Key.

Cheers,