Display Name, but use ID

Hello,
I am new to this forum and to OpenOffice.
Sorry, I haven't found easy solution for my question, maybe not good in search ))
Here is my question:
I have 2 very simple tables.
Table "Operation"
ID, Name, ProjectID (it's for relationship with ID of second table)
Table "Project"
ID, ProjectName
In Operation form I am creating Listbox for ProjectID with data collected from "Project" Table ("ProjectName")
In the dropdown list I see Project Names. But after I choose the right name, I see just ProjectID.
I want the form to show ProjectName.
Could someone help, please?
Thanks.
I am new to this forum and to OpenOffice.
Sorry, I haven't found easy solution for my question, maybe not good in search ))
Here is my question:
I have 2 very simple tables.
Table "Operation"
ID, Name, ProjectID (it's for relationship with ID of second table)
Table "Project"
ID, ProjectName
In Operation form I am creating Listbox for ProjectID with data collected from "Project" Table ("ProjectName")
In the dropdown list I see Project Names. But after I choose the right name, I see just ProjectID.
I want the form to show ProjectName.
Could someone help, please?
Thanks.