Datatables API Show/Hide Record Details

en-motion

I'm using datatables to pull info from my db and display it in a nice logical way. So far, all is good. I'm now looking at the show/hide functionality of it. I can show details for each record in my table. Currently these are all the same as I'm using aData[1] etc. I have another database on same server which has tables that correspond to the records in my row eg. Product Details, Click show - get installation details. Is it possible to link these 2 databases this way using show/hide or does all info need to be in same table in db?

Cheers