Jump to content

Value lists in portal


thierry.be
 Share

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

Recommended Posts

Hello everybody,

I have a portal question:

I am making a database for this particular question 3 tables are important:

1. Table items : 1 item consist of different vendorjobs (relation 1-n)

2. Table vendorjobs : here we have the name of the job, start date, end date, etc

3. Table Vendor : 1 vendor can do more vendorjobs (1-n)

What I have now.

In the table items I have a portal with all the vendorjobs in it. The name of the job, the dates and the vendorname.

The vendorname is actually a value list with all the vendors in. (linked with vendors)

What I want to do is :

I want to add a field called vendor function in the table vendor.

This field also comes in the portal. in the client table.

Now instead of showing a value list with alll vendors, I first want to select a function in a function value list. If lets say I have a function 'translator'. Then when I select translator in the portal, the value list of vendors should change and give only vendors that are translatoors.

Is this possible? If yes can anybody explain a bit how this is usually done,....

Thanks anyway.

[ March 20, 2002, 07:35 AM: Message edited by: thierry.be ]

Link to comment
Share on other sites

Hi Thierry,

I see you are getting on with your files.

What you want is fairly simple to implement.

You need a global field called functions [global text].

Now, create a relationship from this field to your functions field in the vendor table.

Now you can create a value list called functions in your main database. Choose show values from field and then only related values. Choose this new relationship and select your vendor field.

So, on your layout, format your global field to a pop up list of functions.

Now set your vendors to use your the above value list.

HTH

Link to comment
Share on other sites

This topic is 7144 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.