I have a Postgresql database - Finance, that has 2 tables - Institutions and Investment. An investment is linked to an institution name and there is a foreign key constraint that links these 2 tables (inst_name in Institutions and Investment).
I connected this database to Libreoffice Base and created a form from wizard on Investment table. I tried to replace the institution field in this form with a list box so that I can create a lookup to the institution master. However when I go to replace with field, it shows no selections possible.
Alternatively, is there any way to build a lookup in the form?
Thanks in advance
Sachin