Hi Guys, I have tried to keep this simple, I have the following table relationships:
Client ----< Properties ----< Assets (i.e client has many properties, a property has many assets).
The Assets table has these fields:
#Property (lookup)
#Asset Name
#Asset Number
I have a view that displays:
#Client (related field to property - Linked)
#Property
#Asset Name
#Asset Number
This works fine, except I am not able to include a filter in the URL that filters on the client field (e.g. ...#View:Assets_View?Client=Sorbon) . All the other fields are fine, just not the client field (which of course is a lookup).
Any suggestions?