Linking to custom user form from list - how?

[redant]

Hugh and Troester - thanks for staying with me on this one!

Hugh, it's working now. Thank you. I cannot believe I overlooked the ...._raw element after reading so many posts and then Murphy's Law being what it is I found this post this morning which describes pretty much what I have been trying to acheive: http://fabrikar.com/forums/index.php?threads/solved-passing-variables-to-a-form-using-url.41059/

Appreciate the help guys.

Now - how do I mark this thread as solved and closed ....?

 

[cheesegrits]

Thread tools menu.

 

[redant]

Sorry guys. I've had to reopen this. Although the custom link is working, I'm still being presented with the incorrect record and I suspect its me not understanding how Fabrik sets up database joins. I've read a lot of post, viewed the tuts, etc. but its still foxing me. So using my own advice about less words=more clarity ...

What I'm trying to achieve:
(Step1)Form-"Select Destination" (on submit) ->
(Step2)Show pre-filtered details from List-"Drivers going to Destination" ->
(Step3)On click details show form-"Driver Details"

My settings:
Table - "Drivers going to Destination" has field userid (value = 295)
Table - "Driver Details" has field userid (value = 295)
Table - "Driver Details" has PK id (value = 9)

Element - "Drivers going to Destination.userid" has query:
(SELECT DriverDetails.id
FROM DriverDetails
WHERE DriverDetails.userid = DriversGoingToDestination.userid)

On (Step3) of the workflow I expect the resultant URL to be: ....&rowid=9
Instead I get: ...&rowid=295
and an error messsage 'We are unable to find this record'

The query works correctly in my sql IDE (Toad for MySQL)

I have also tried a list join and removed the element query and get the same result.

Please tell me what I'm not understanding ...

 

[redant]

Thanks guys - I managed to work it out using this thread from Rob: http://fabrikar.com/forums/index.php?threads/database-join-elements-and-linking-advice.6172/

Cheers.