Help using Listbox to return 2nd field value

[KCPhoto]

I have a question about this form.



This list box (Products in the subform) uses an SQL statement to show the Description field from the table Products. When I select an item from the shown drop-down list of this listbox, I want to pass the Price from the Products table to the next field in this subform (Next column after the listbox).

In Access I did this with a ListBox that contained 2 fields, I can't do this in OpenOffice. I don't need to see the value first, just pass it to the Price field. I saw several posts about concatenating data & using Message Boxes to view the data. I don't need to do that.

Can anyone help me with the code or process to pass Price from table Products to the ItemPrice field in the InvoiceItems table when selecting the Product from the listbox. The subform with the listbox is based on the InvoiceItems table.

Here is my database relationship structure.



Thanks,
Kenny

[RPG]

Hello

In this post dacm explains a method how to set up a database in which you have not to calculate those values. Also you can find there a link what is pointing to an example.

Here you can find that even with an example it is difficult to do. But other people give also some explanations what can it make more easy for you.

I think you must learn the term we use in OOo-base. You talk about your form document as a subform but I think you mean the document. A subform is a part of a mainform as you see in the form navigator. A mainform is not the form document.
http://user.services.openoffice.org/en/forum/viewtopic.php?f=83&t=28235

Romke