First time here? Check out the FAQ!
asked 2012-04-16 09:18:44 +0200
I created a form (with a subform) and I have a person ID in the form. I would like to show name of that person: Select name from person where person_id = ID where ID is the field on my form. How can I do that?ű
answered 2012-12-27 12:28:18 +0200Bwmove
Check this tutorial "From Newbie to Advocate in a one, two... three!" by Mariano Casanova It will answer your question. But for that you have to make a query with SQL:
SELECT "First Name" || ' ' || "Surname" AS "Name", "ID Number" FROM "<your table="">";
Then rename it like "qryListName" (or something else you want). Click with the right mouse button and set "create as view" and set the name like "vListName" (or something else you want). This new table will appear on the Table section. Now set this new table vListName as the table of your subform or a dropdown list from a text box, etc.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-04-16 09:18:44 +0200
Seen: 84 times
Last updated: Dec 27 '12