How to link 2 entities with a 0 to many relationโฆ Hi, I got a small thing with DeliveryRoutes and Orders. The Orders Table contains a DeliveryRoute Ref field set as not required. This table is already filled up with data where DeliveryRoute is by default empty.
What i am trying to implement is a way to Link these orders to a delivery route, meaning by:
Selecting a Route and from this route have a list of Orders with checkboxes to add them to the route. (i guess it should be a form with a list of Orders and a field to sequence them)
I ve been looking for a few hours now with youtube videos etc and couldn t find anything related, any clue ?
How would you like to show those Orders in your app? What are you going to do with them?
@Aleksi_Alkio Hi, My problems isn t even on how to show it for nowโฆ it s on how to assign it. My Orders come from another app and are imported with no delivery route set. So basically i want to
How about like thisโฆ
@Aleksi_Alkio Exactly !
Send me your email address and I will share it to you. Much easier to understand aleksi@appsheet.com
Shared
I am checking, yesterday i stall had a small problem but probably did i do something wrong
@Aleksi_Alkio Ok i got it orking but how would i change the name of the blocks to select the orders ? because mine use id as key and i d like to show a virtual column containing clientname and addressโฆ
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |