Apologies for a ridiculous problem, but it's one I can't get past.
I have two lists:
Shops - this contains Shop addresses and Shop numbers. The Shop Number column has an underlying Field name of "Title". This is NOT the auto-gen ID column incidentally, it is a Text field that happens to contains numbers of shops.
Faults - this contains calls logged to each Shop - the user chooses a Shop Number (lookup column to Shops list) and then types the fault details.
I want user to be able to see Faults logged against each Shop when they view the Shop list item.
So I am editing the DispForm.aspx page for Shops, where I've added a DFWP containing fields from the Faults list.
How do I show only those items in the Faults list, where the Shop Number on the FAULTS list equals the Shop Number of the currently-displayed SHOPS list?
Creating a parameter Query String for ID - but that won't work because the ID passed in the URL is NOT the "Shop Number"
Creating a parameter From field - but what do I type to reference the Shop list and the Shop Number ("Title") column?
Creating a Filter? I've tried several, but I have no way to reference the Shop Number ("Title") column on the form.
I've created a Custom List for Shops, and dro
View Complete Post