Issue 83652 - Base to ask how to handle deleting fields in a relationship
Summary: Base to ask how to handle deleting fields in a relationship
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.3
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2007-11-15 07:14 UTC by hantwister
Modified: 2013-02-07 22:42 UTC (History)
1 user (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 hantwister 2007-11-15 07:14:02 UTC
I consider the following an Enhancement request.

Presently, if one were to have two tables that were related, should the user 
try to delete one of the fields in either table that relate the two tables to 
each other, Base will not initially complain, but will throw an error upon 
trying to save the table.

Would it be possible to, instead of simply giving an error upon trying to save 
that the Field cannot be deleted, when the user initially tries to delete the 
field, ask the user if he/she is sure that they want to delete both the field 
tying that table to another and the relationship(s) with a Yes/No Dialog, and 
possibly if the user would also like to delete the related fields with a 
checkbox in the Dialog (by default unchecked)?

Steps to reproduce:
1. Create a database in Calc.
2. Create Table "Table 1" with Primary Key Field "Field 1A" and Field "Field 
3. Create Table "Table 2" with Primary Key Field "Field 2A" and Field "Field 
4. Open the Relationships Window.
5. Add both "Table 1" and "Table 2" to the Relationships Window.
6. Drag "Field 2A" onto "Field 1A".
7. Save and close the Relationships Window.
8. Open the Design of "Table 1".
9. Try to delete "Field 1A".
<Requested feature would go here>
10. Try to save the Design of "Table 1".
<Current implementation occurs here>

-Harrison N.
Comment 1 christoph.lukasiak 2008-05-07 10:00:28 UTC
Comment 2 christoph.lukasiak 2008-05-07 10:01:23 UTC
send further to the erquirements team
Comment 3 christoph.lukasiak 2008-06-18 13:05:59 UTC