what i'm looking to do is pretty obvious stuff but really struggling to find a way.
basically i have a database form that i want to insert a combobox into. that combobox will contain entries from a database field. those steps are easy via the oobase2 interface. next i want call out to a java function when the combobox is updated. this script will lookup the primary key of the selected item and update another, bound control on the form to the correct value. hopefully this will update the database. there are only two objects available from the script event. the event and the script context. i therefore have the event and the document. it would therefore seem simple to access the document (via script context) to get the Forms root or access the form via the event source (via the event). i could then search the form for the other control and update it with the necessary value. unfortunately, as the database document does not seem to support the the DrawPage interface (presumably because the actual form appears to be a writer document) i am unable to figure out how to obtain the Forms root .... or even better just the form node i need, so that i may locate the second, bound, control item. option two was to find the parent of the control which would presumably be the form and search for the required peer item. this also appears impossible as the control is not actually a FormComponent. my current thinking is that, if i get the component context then i could instantiate (via XMultiServiceFactory) the Forms service and thus the Forms root. if this is the correct route i need some help in doing it as i fail to understand the service instantiation service correctly (in this context at least) ... i.e. does this actually create the Forms root, and if so what service name do i need to use cause "com.sun.star.form.Forms" doesn't appear to be it. perhaps there is an easier way to bind one field value to a combobox and display the list from another field but i cannot find it. tried using a select statement that returns two fields but no joy. anyway, any guidance much appreciated. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
