Sorry, another conditional value list problem. : After days of searching for an answer I need some help. I have managed to create a conditional value list whereby listB is restricted to items by ListA.

What I need to know, there are two further fields, (attributes), that I want to auto complete based on the field information selected in ListB. I have tried selecting these fields to auto complete but they don't work.

sample.zip

Hi Ghost,

Are you sure you've got your terms right?

Do you want them to fill in by themselves, provide the user with a list to choose from (which has been narrowed down by selection of the style name / code) or do you want it to just predict what the user is going to enter based on what has previously been entered into the field?

I think the file I have just now posted here:

http://www.fmforums.com/forum/showpost.php?post/254381/

might be applicable to your situation too.

Hi Genx,

Thank you for your prompt reply.

If you check the products file, you will note that every style code only has one screen print and colour associated with it. By narrowing down the "order" we use firstly the style name, then the style code, the remainder of the attributes should automatically be inserted as they pertain to only that style code. They will not be editable, at least not in the portal. Seems so easy, but I fail to get the other two fields to complete automatically.

Hi Comment,

Thank you for your file, but alas, it isn't quite what is required. I already have a lookup for the price. I tried a look up with the other two fields but it doesn't give the correct attributes. Seems to work easy with a price lookup, but in a portal, for text it doesn't happen. With your file, if you associated two other unique attributes to the product before the price, place it all in a portal, and try and get the other two fields to automatically complete after selecting the first two conditional lists.

Sorry if I sound a little long winded.

Change your relationship between men and products to style code = style code.

Hi Genx,

Seems so simple, However, although that does the trick for the portal, it doesn't update the consolidated file now because the order ID relationship has been deleted. I even tried just adding the extra relationship but that doesn't work either. :

Add another table occurance of products called Products_2. Keep your original relationship as it was. Between Mens and Products_2 add the relationships style = style code. Source the two fields in the portal from Products_2 not products.

Cheers Genx. This works fine.

(Just seems silly to keep having to add table occurrences though).

Many thanks for your help. I am sure I will be posting more questions in the future.

Don't be afraid to add TO's where they are necessary. They don't hurt, they don't blow up your size and are normally more efficient than other methods... But don't over do it where it's not necesary either :

They don't hurt, they don't blow up your size and are normally more efficient than other methods

If your scripts gets cumbersome to trace the flow in, is the above advice usually the real answer to the problems the script seeks to solve...

--sd

all advice appreciated and taken on board :