Ask Your Question

In Base, is there a way to have a list box with autocomplete, or a combo box with different data? [closed]

asked 2013-05-11 07:41:54 +0200

Jason Liu gravatar image

updated 2013-06-11 18:58:01 +0200

manj_k gravatar image

According to Chapter 4 of the Base Handbook, the section on List Boxes states that, "A list box shows the user different data from what is actually transmitted into the table." On the other hand, the section on Combo Boxes states that, "Combo boxes write the selected text directly into the table underlying the form."

I am working on a private tutoring database. Suppose I have a combo box that has a list of student names (populated from a table called Students). I want the user to be able to start typing in the combo box and have it autocomplete the student's name. Then, when the form gets saved/submitted, the StudentID (the primary key in Students) is the value that actually gets written into the Payments table. Is there any way to have the autocomplete goodness of a combo box, and yet have the actual data that gets written to the table be different than the selected text? Could I do it with some sort of SQL statement? Or is it time to resort to a macro?

In Microsoft Access, this functionality is apparently called a "lookup field". In this post, there's mention about foreign keys, but I'm not really sure how that relates to a combo box.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-31 16:33:08.311424

1 Answer

Sort by » oldest newest most voted

answered 2013-05-11 14:36:55 +0200

oweng gravatar image

There are probably several ways you could go about this. I think what you are after may be a List Box, as indicated in this answer. The Project / Sponsor table arrangement in that example would appear to be quite similar to your Payment / Student example.

edit flag offensive delete link more

Question Tools


Asked: 2013-05-11 07:41:54 +0200

Seen: 4,364 times

Last updated: May 11 '13