Portal relationship problem

[James Patrick]

Hello,

I am having problems trying to get a relationship to work in my database. I am new to all this and what I am trying to do is a bit above me so any help would be greatly appreciated.

Basically I have 3 tables contacts, jobs and clients. On the jobs page I have a portal which shows the client name and the company they work for, this data is taken from the other 2 tables. What I am trying to do, unsuccessfully, is have a button in the portal which when clicked displays client info, such as company name and address, and contact info, such as contact name and telephone number, from there respective tables, on the jobs table. I have put a button in the portal with a script that goes to related record, but the problem is I am going to 2 related records, and I am not really sure what the best way around this is.

I hope this makes sense, any ideas would be greatly appreciated, I have attached a sample file.

Thanks

James

test.zip