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?ű
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?
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
“”;
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.