Issue 62143

Summary: automatic lookup table, lov, list box
Product: Base Reporter: soloturn <soloturn>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.0   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description soloturn 2006-02-16 13:07:47 UTC 
oo base does not provide an easy way to specify list boxes for foreign key
lookups. it would be great if this would be more easy:

1. automatically display a list box if hit a foreign key field while entering
data in a table.

2. specify the query and look of the list box when defining the tables foreign
key field.

3. if the list-box is displayed, entering characters should narrow the displayed
result.

4. allow to add a row to the lookup-table if you notice your value is not there.
maybe display a second button on the side of a dropdown, or have a value "<new>"
on top of the presented list.
Comment 1 Joost Andrae 2006-02-16 14:09:15 UTC 
Regarding the definition of issue priorities
http://www.openoffice.org/scdocs/ddIssues_EnterModify.html#priority
this enhancement request cannot be P1.
Comment 2 christoph.lukasiak 2006-02-20 12:12:26 UTC 
send further to 'requirements'