Does anyone have sample code that can show me how to link a drop down to a remote database tableie: I have a list of projects by year and I would like to have the drop down show me all projects for 1 specific year where more than 1 year is present.I am not sure which way to do this, read all the dat...

Oh, interesting that the 64 bit ODBC works fine with Microsoft Access to link into the SQL database.I can see and update the tables fine.So, my first thought would be that LiveCycles has a problem on Windows 7 64 bit or some settings that I am not aware of that need to be set.

Anyone that you can ask at Adobe that may know about any such issues?

Hi PaulI am trying to get the 32 bit drives to work connected to a SQL remote database and I get the following errorGeneralError:Operation failed.......Index is out of boundsI am using a simple script to clone the datasource so a drop down can bring up the other row valuesThe lines that it is failin...

Curious, has anyone recently ported over to Windows 7 64 bit version from Vista and having ODBC issues?I have a very simple form that works fine on Vista 64, but when I connect with Windows 7 64 bit,  it stops working.Looks like the 32 bit ODBC drivers work a little better, but not much.So questions...

This is probably a very dumb question, but ...I have 2 forms, one is working great, reading from the database and showing the drop downs properlyThe other is set up the same way, started from a new form, but is not allowing any drop down interaction.Just shows the first record. and is greyed out.Que...

No errors reported.

wrtAre the values that populate the DDlists in different tables or the same one? - Yes different onesIf they are in different tables then I think you  will need a different data connection per table. I agree.If they are the same then you shodul be able to define the SQL statement that you want to ru...

Hi PaulFirst - thanks for the tips so far!Working on a project that requires 2 drop downs to filter the next third drop down.Need user to select ClientID and YearIDI have the code working for the first dropdown (ClientID), but unable to get the second drop down to show JUST the data related to the s...

Hi, Using the arrays looks great for what I need to do too.But the data is hard coded and thus not as flexibleeg: you use var caCodeStr = "Canada,AB,BC,MB,NB,NL,NS,NT,NU,ON,PE,QC,SK,YT";If this data was in a relational database that I want to connect to One table with CountryID and CountryName and o...