Linking tables - hyper link to extra information.
Posted: Wed Jun 03, 2009 8:22 amHi there,
My questions involves how make one of my Xataface result fields a hyper link to a different table that contains the additional information about that field/ entry.
I am working with a MySQL Database for tracking computers / and devices - -using
Xataface-1.1.5
Each computer / device has an "owner" field which is part of the device query - and the list of possible "owners" comes from a _SQL_ query to a table called PEOPLE - That PEOPLE table also has extra notes & info about each PEOPLE entry.
-
So when a user looks up a computer or device, I would like them to be able to double-click the "owner" name, and be hyper-linked to the PEOPLE table / "owner" entry where they can see the extra notes, and full information about that "owner".
Thank you for any help or suggestions.
~B
My questions involves how make one of my Xataface result fields a hyper link to a different table that contains the additional information about that field/ entry.
I am working with a MySQL Database for tracking computers / and devices - -using
Xataface-1.1.5
Each computer / device has an "owner" field which is part of the device query - and the list of possible "owners" comes from a _SQL_ query to a table called PEOPLE - That PEOPLE table also has extra notes & info about each PEOPLE entry.
-
So when a user looks up a computer or device, I would like them to be able to double-click the "owner" name, and be hyper-linked to the PEOPLE table / "owner" entry where they can see the extra notes, and full information about that "owner".
Thank you for any help or suggestions.
~B