I have 2 collection, A (Master) and B (Detail), where B has a ref-field to a column (Primary Key) in A.
I would like to make 2 lists:
- show all B´s and info from A
- show all A´s and display any B´s (thus : also A´s without B´s)
I thought I could click my way out of it. List 1 is not a problem, but I cannot make list 2: I see no option to link A to B, or, more specific, on the Primary Key field in a, I cannot link the ref field in B.
I know how to do this in code, but I wonder if this is possible without coding? Am I overlooking something?
EDIT : to make it clearer, I am looking for the equivalent of an SQL Left Outer Join.
EDIT2: and for doing it in code, I would do it like this: get all A´s within criteria, for each A, display it, query B for any existing rows with same _id, display it, next A, etc
This will take many queries: is there a quicker Wix alternative to this?