Unique values in drop down list from Access

[BRN]

Hi there,

I'm new in InfoPath 2003 SP1, I'm having a form working great, but I
would like to improve some things like this...

I want to avoid from duplicated date inserted into database from
repeating tables. My form is connected to a MS Access database where the
primary connection goes to and also I have a few Access queries ready
for secondary sources to fill up drop down lists.

I have followed a few examples I have found on the net, like
infopathdev.com - they used preceding function, but not with Access, or
infopath blogs on MSDN web - they used xdXDocument:get-DOM() function. I
didn't managed the second example, but the first one with no problem.
When I wanted to move myself with the same idea to my database and form,
it didn't worked. Maybe I've got just some misspelling, it still does
show all values and not only those which are not in the list already.
This is in repeating table.

Here is my scheme:
Beside from others my form collects details about companies like for ex.
regions of the country where they do operate. This is separate table
linked using company_id field to the main database. My drop down list is
filled up from main database from a access query and saving data to
primary source.

RegionOperateNumbers
|- RegionOperate_ID - unique (autonumber)
|- Organisation_ID - linked to main database
|- Regions_ID - value from query

If someone can help me, I realy appreciate this, I'm not experinced in
XDocument funtions and syntaxes.

Thanks Brona

 

[BRN]

Hello again,

did anyone tried to connect to Access database using secondary
connection and trying to list only those values in drop down list which
are not already selected within repeating table ? Please advise, I have
found it very useful to put that into my form.

Thanks a lot in advance, any help appreciated

Brona