Value lists in portal

[thierry.be]

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 ]

[andygaunt]

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

[thierry.be]

Andy,

I tried your solution and of course it works, so again, thank you for your help,

Thierry

[andygaunt]

No problems,

glad the files are working for you now.