Ask Your Question

Dynamic text in base [closed]

asked 2012-04-16 09:18:44 +0100

anonymous user


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?ű

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by qubit
close date 2013-01-26 21:12:46.374545


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 gravatar imageDonLow ( 2012-08-19 23:20:04 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2012-12-27 12:28:18 +0100

Bwmove gravatar image

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.

edit flag offensive delete link more

Question Tools


Asked: 2012-04-16 09:18:44 +0100

Seen: 201 times

Last updated: Dec 27 '12