relatedRecords showing all

Hello,

I have a table, 'accounts' and 'bookings'.

Each 'booking record' is related to one 'account' record.

So, to show related records in Bookings table, I use:

Related Table: accounts
mysql Where: num='<?php echo mysql_escape(@$RECORD['customer']) ?>'

Now this works perfectly fine when I am logged into the CMSB with the master Admin account - I see the ONE related customer.

However, logged into the CMSB with a non-admin account (but with editor access to both these tables), the releated records section shows every single customer, like it's not applying there where criteria.

Very odd that it works fine for main admin account, but not others.

Any ideas what would cause this?!! Thought possible access rights, but the other account has editor access to both accounts & bookings...

Cheers