asked 2012-04-16 09:18:44 +0200
Anonymous
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?ű
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
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
As of today, this question has been viewed 29 times, with no comments or answers. I think that is because we don't understand what you are asking. (I know I don't) Could you expand or elaborate on what exactly you are asking?
DonLow ( 2012-08-19 23:20:04 +0200 )edit