Newbie Questions

Re: Validations of two drop down box

NWFTC — Mon, 20 Feb 2012 19:07:53 GMT

thanks it working fine now.

Re: Validations of two drop down box

Hilary Stoupa — Mon, 20 Feb 2012 18:32:51 GMT

Everyone has been new at this at one time or another.

Here's what I did.

In your form, the main data source "Supplyer" field is using a drop down on the form for the control. You've set that drop down to use the ID from the Suppliers data source for its value.

So, for the Account No. field in your main data source, I set a default value (right click on the field in the Fields pane and look in the properties). The default is the ACCT NO. ("Column7") from the same Suppliers data source. I added a filter - where the ID = the main data source Supplyer field.

I added the same filter for the drop down entries for the Account No. field - and used the same Suppliers data source.

Re: Validations of two drop down box

NWFTC — Sun, 19 Feb 2012 20:25:17 GMT

I have just about got it working, the problem seemed to be i had not created a secondary data connection. now that i have it is near completions but the selections of accounts are shown blank.

I know you have been very helpful and this may feel like teaching a kid but if you dont mind it would help a lot.

Re: Validations of two drop down box

Hilary Stoupa — Fri, 17 Feb 2012 18:35:31 GMT

Well, I did what I could without being able to actually preview or test in your environment. You've got a drop down on that account number (so of course the user can select another one). I've got no way of knowing what your secondary data actually looks like - Your drop down for "Supplyer" uses the ID for the value - perhaps the other data connection uses the display name instead of the ID?

Re: Validations of two drop down box

NWFTC — Fri, 17 Feb 2012 18:22:58 GMT

Ok Done that and published it to SP2010 but when selecting supplyer the account number has not auto filled and still allows me to selelct the any other account number

Re: Validations of two drop down box

Hilary Stoupa — Fri, 17 Feb 2012 18:12:17 GMT

You have to save the file locally then right click the saved XSN and select Design to open in IP Designer.

Re: Validations of two drop down box

NWFTC — Fri, 17 Feb 2012 18:04:00 GMT

cant open it as, tells me that it is reg to your domain

Re: Validations of two drop down box

Hilary Stoupa — Fri, 17 Feb 2012 17:30:39 GMT

The XPath for the default looks like this:

xdXDocument:GetDOM("Suppliers")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Column7[../d:Title = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Supplyer]

See attached template.

Re: Validations of two drop down box

NWFTC — Fri, 17 Feb 2012 17:24:59 GMT

Dont be sorry it is me not being able and work long shifts, too tired to make it out

Re: Validations of two drop down box

NWFTC — Fri, 17 Feb 2012 17:18:47 GMT

THanks

i will look to see what iwas doing wrong when i get it back.

Also found this that may be of use when hiding fields

http://blog.symprogress.com/2011/05/infopath-list-form-hidedisable-fields-based-on-sharepoint-group-membership/

Re: Validations of two drop down box

Hilary Stoupa — Fri, 17 Feb 2012 17:08:59 GMT

If you attach your template to a reply, I'm happy to simply put this in place for you.

On your form, you have a drop down control, correct? The user selects a supplier from it.

This control is bound to a main data source field.

If you right click the control, and select the control's properties, the main data source field's name should show in the control properties.

In the third dropdown in the screen shot you display, do you see where you have currently selected the Acct NO field?

Instead, you need to select your main data source field that is bound to the drop down where your users select a Supplier. I'm sorry, I just don't know how else to explain this.

Re: Validations of two drop down box

NWFTC — Fri, 17 Feb 2012 17:00:10 GMT

Sorry i am completly lost witht he main data and other thing here. Is it possible to send a pic of how to do it

Re: Validations of two drop down box

Hilary Stoupa — Fri, 17 Feb 2012 16:35:03 GMT

Okay, so in the 3rd dropdown in that screenshot - Acc. NO - is that from your Suppliers data source? What is the field in your main data source that is bound to the dropdown where the Supplier is selected? In the 3rd dropdown in your screenshot, select a field or group, navigate to your main data source, and select the main data source field that is bound to the dropdown.

Re: Validations of two drop down box

NWFTC — Fri, 17 Feb 2012 06:56:07 GMT

Screen shot attached.

Re: Validations of two drop down box

Hilary Stoupa — Thu, 16 Feb 2012 19:24:21 GMT

When you reply, using the Reply button, there is an Options tab. at the top. You can click on the options tab to attach a file.So you can attach a screenshot that way, or the form template you are working on.