Three tables portal

[lostgirl]

Hello again peepz,

Please refer to the attached files for a visual idea of what I am trying to do. Basically when I click a row in the portal located on the right top half, it should display the details of the records on the right bottom half. However, I cant seem to find a way to do that.

Could you guys tell me how to do that? I believe it has something to do with the relationships between the contractor and refurbishment tables but I don't know how to sort it out.

Regards,

Farah K.

Edited June 20, 2008 by Guest

[jstaphse]

This sounds like what I mentioned Here

Edited June 20, 2008 by Guest
iphone typing mistakes

[lostgirl]

Dear jstaphse,

Thanks for the info but I am taking data from 3 different tables. You are using 3 tables but one of them is actually an occurance. Any suggestion on how to tackle this?

Regards,

Farah K.