...well, I seem to be stuck trying to gather information for a portal. I am attempting to pull up a list of 'patients' other than the one in the main screen. The way I have joined them is their 'Patient_ID'. There are two tables; 'Data' & 'Data1' which cloned itself for the join I guess...

But, after I create the portal there is simply no fields filling in...I have joined using;
'Patient_ID' = 'Patient_ID' and
'Patient_ID' =/ (does not, couldn't find proper key stroke here) 'Patient_ID'...

Help is VERY appreciated...I am in FM7 on Windows by the way...

Leoff

I believe your first relationship pair should use the "X" operator, not the "=" operator.

Best,

John

I did use the equal sign 'and' the not equal sign...what's the difference with the 'x'?

B-I-N-G-O!

Actually, the first criteria (PatientID x related::PatientID) is redundant.

PatientID <> related::PatientID will match all other patients' records all by itself.