I have a main table that contains all our sales prospects and all have different postcodes. What I want to do is create a linked database from our main databace that just certain postcodes that I enter in a list.

Certain people will be allocated specific postcode areas to work with, so I want only certain postcode areas visible to certain people.

For example, if I have postcodes BR1 to BR8, I would like to be able to have only BR1 to BR5 show in a particular table from James. BR6 to BR8 for Jenny.

"create a linked database from our main databace [sic]"

I don't know what you mean by this.

If you create a postcode assignment table, that has the PersonID and the Postcode, then you could create a rla calculation that only allows view of the sales prospects that contain matching postcodes.

So, a person logs on. You gather their allowed postcodes in a $$var using SetField (List (relationship:PostCodes).

Your rla calc would allow view/edit if Patterncount ($$var, PostCodeID).

see demo, user: admin, no passwords

PostCodes.fp7.zip

Edited August 26, 200916 yr by Guest

Thanks for the reply

I intend to use IWP. I meant a linked database as I thought it would be better to start a new IWP database and link to our main sales table.