customerid = id
In the user table, ie tbl_directorylistings the id column = customerid in tbl_posts. CommunityID is for the physical location id - we have them grouped into physical location groups and and have community managers for various groups and want each community manager to be able to edit only the listings in their territory. If you could kindly advise for rule for communityid and customerid that would be GREAT. I really appreciate your prompt and excellent support.