You’re offline. This is a read only version of the page.
Announcements
2
I am trying to get a many to many relationship working for my canvas app
I have two tables:
Users : ID, Name, AssignmentID
Assignments: ID, Name
they both have a N:N relationship going both ways.
I have no columns that can have more than one value at a time, which goes against what I am trying to achieve. I am trying to make it so that I can add multiple values to a lookup field.
I see a lot of guide suggest I use the Relate() function in the canvas, which defeats the purpose.
please if you have any suggestions as to what I should do
You can nest your lookup, similar to this example
Filter(
Search(
WhCountingLines,
Dropdown4.Selected.Value,
"binCode"
),
itemNo = Warehouse_Receive_Detail_Screen_Input_SearchScan_6.Text
)
Share
Report
All responses (
Answers (
