relatedRecords showing all

3 posts by 2 authors in: Forums > CMS Builder
Last Post: August 10, 2011   (RSS)

By rjbathgate - August 9, 2011

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

Re: [rjbathgate] relatedRecords showing all

By Jason - August 10, 2011

Hi,

If you could fill out a [url http://www.interactivetools.com/support]2nd Level Support Request[/url] we can take a closer look into this problem for you. In the request if you could provide the CMSB login details for the admin and a non-admin account that would help.

Thanks
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/