One way you can do this I believe is using scripting language, either formcalc or javascript in the xdp. I am assuming you want to do this interactively, so a user is typing in data real time. You could do something like this (Syntax might be incorrect, but this is the jist of it).
One field must be a drop down menu and another a text or decimal field (kinds could be changed).
For example: I´ve linked the drop down field with the "service" field in the table ODBC database.
The decimal field is binded with the "price" field in the ODBC database.
So, in the drop down field I have the choices: Colorization / Photograph / so forth.......... in the decimal field I have 110 / 30 and so forth
I´d like to choose colorization in the drop down and the decimal field automaticaly updates. It´s like doing a search on my database and display the price based on the service I select.
How do I program it?? I have no ideia... All of it is new for me..
I´m sorry for posting in a wrong forum. Let me just finish solving this problem even here.
I think you did not understand. Let´s try explaining my problem again.
I´ve created an database using Microsoft Acess (database.mdb)
That drop down and decimal field are linked with that database (one for each column of my table).
I´ve already linked that fields with the column of my source table.
So colorization and photograph as well as 110 dollars and 30 dollars are registered in the database.
For example: I need to choose colorization in the drop down field, automaticaly the decimal field fits proportionaly to display the price.
I think behing all of that is when I choose colorization in the drop down menu, LiveCycle acess my databese and put the price in the decimal field according what I´ve registered in the database.
I think you'll have to repost on the right forum. We don't ever do any work directly with databases, we always go via web services, so I don't know how to do this.
Sorry...
You can see an example of how to do something like this (using web services) here:
