Jump to content

Help with portals please


tex_zero
 Share

This topic is 7346 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I'm building a DB to manage distribution of my clients product into a network of retail agents.

To do this I've created two files. File one contains my six clients. File two contains the details for the retail network of 5,000 agents.

I've created a relationship between the two by adding a "key" field on both files which auto adds the letter "A" to the field for all clients and agents. This allows me to create a portal on each agent (file two) record which displays a list of the clients from file one.

While all the retail agents are used by all clients they categorise them independantly (A, B, C, etc.) based on sales performance.

My problem is this. Is there a way to add a field to each client record displayed in the portal on each agent record which allows each client to categorise each agent independantly?

I've tried to do this but changing one field in the portal affects all the portal fields.

Any help much appreciated.

TIA

Link to comment
Share on other sites

This topic is 7346 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.