Issue 65079 - cannot find lookup function
Summary: cannot find lookup function
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.2
Hardware: All Windows XP
: P5 (lowest) Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2006-05-04 13:35 UTC by stuurman3
Modified: 2013-02-07 22:38 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description stuurman3 2006-05-04 13:35:38 UTC
As in MS Access, for inputting data in  Base I would like to lookup values in 
a field, which may be stored in another table. I cannot find this function in 
Base nor in the Help. Is this missing? or is it hidden somewhere?

Ex. In a Contacts table I have a field called ContactsType. This field should 
only be Competititor, Customer, or Informant.
Comment 1 ibarnard 2006-05-04 14:00:28 UTC
You're right about this. Although OOo Base gives similar functionality, it's
only available in a form, where you create a drop down list which reads its
items from a table or query - does exactly what Access does but not automatic.
It would be nice if you could also set the table to have a lookup setting for
any aprticular field, which would then be automatically created as a combo-box
whenever you place this field on a form - similar to Access where you don't need
to specify the lookup values, table or qruery every time you place the
particular field.
Comment 2 marc.neumann 2006-05-04 14:30:23 UTC

I reassign this enhancement to the User Experience team for evaluating.

Bye Marc
Comment 3 ultrarunner10 2007-12-02 20:44:59 UTC
I too would like very much to have the lookup feature added to the tables. It is
a very useful feature of Microsoft Access and I would greatly enjoy using it in OOo.