Quote:..Is there a problem with trying to delete a database that's at a lower level than others in the application? ...
... Is there a way I can move Database 2 to the same level as the others? If not, how do I delete it.
Hi Bobbi -
You're asking two questions here - I'll answer them both.
You can delete any database in Field Manager...
1. In Designer go to Manage a Database
2. Select the database you want to delete
3. Select Manage Fields.
4. From the 'Action' dropdown select "Delete Database"
(there are no further options for this action).
5. Click on "Add Transaction to Batch".
6. Click on "Run Batch".
7. Confirm that you want to delete the entire database and kiss goodbye to all the forms, data etc in it.
BUT.. what you really want to do is to re-parent the subform/sub-database. Yes you can do this too.
I'll use as an example the COUNTRIES application.
This consists of two databases, COUNTRIES & CITIES. Cities is shown as a subform on the Countries form. So Cities is a sub-database or child database of Countries. You can see this because it is indented under Countries wherever you see them in a menu tree. What you want to do is to remove this parent-child relationship between them.
In Sesame, you do this the same way you created that relationship in the first place - by manipulating subforms. You created the relationship by adding the Cities form as a subform onto the Countries form. To break that relationship you delete the subform "field" in Countries. These are the steps
1. Open Designer.
2. Open the file SAMPLES \ COUNTRIES.DB
3. Specify the new DSR file UNPARENT.DSR
4. Go to Manage a Database
5. Select the database COUNTRIES
6. Select Manage Fields.
7. From the 'Action' dropdown select "Delete Field"
8. From the Field Name dropdown Select the field "Cities Subform"
9. Click on "Add Transaction to Batch".
You are told, in red...
"The Subform Layout Element bound to this Field will be deleted from its parent form"10. Click on "Run Batch".
11. Close.
You will now see that Cities and Countries are now on the same level. You can use it now as a subform on any form based on a database at the same level. You will also see there is a blank area on the Countries form where the Cities subform was.