Lantica User Forum - Relationship prevents field deletion.

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Relationship prevents field deletion.

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Pages: 1

Relationship prevents field deletion. (Read 862 times)

WhiteCrow Member Offline No personal text Posts: 16 Location: Germany Joined: Apr 21^st, 2005	Relationship prevents field deletion. Aug 15^th, 2005 at 1:03pm	Print Post
	I am a bit stuck at the moment and would welcome any help. I am trying to delete an unwanted second Database in an application. When using the Field Manager I get the error: Warning! Cannot delete Field. It is used in a relationship. I have gone through the first Database but cannot find a relationship to this field. Is there a way of listing any relationships in use? Thanks.


	IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Relationship prevents field deletion. Reply #1 - Aug 15^th, 2005 at 1:23pm	Print Post
	Is the database you are trying to delete used in a subform? Does it appear under another database on the menu tree?

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

WhiteCrow Member Offline No personal text Posts: 16 Location: Germany Joined: Apr 21^st, 2005	Re: Relationship prevents field deletion. Reply #2 - Aug 15^th, 2005 at 1:47pm	Print Post
	The database was used as a subform twice at some time but I deleted them. The database I am trying to delete is called kjhg which now appears twice, both of which will not die. I just can't find a subform on the 'FrontPage' database now. As for it's position in the tree:


	IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Relationship prevents field deletion. Reply #3 - Aug 15^th, 2005 at 1:56pm	Print Post
	Open the Field Manger for FrontPage and look for fields of type SUBRECORD. There should be two. Delete them both. You should then be able to delete the linked database.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

WhiteCrow Member Offline No personal text Posts: 16 Location: Germany Joined: Apr 21^st, 2005	Re: Relationship prevents field deletion. Reply #4 - Aug 15^th, 2005 at 1:57pm	Print Post
	Hammer, I have found it. What I wasn't aware of is the fact that if I delete a field, it is not actually deleted permanently unless I take it out of the Field Manager. I found the two fields still listed in the Field Manager for the FrontPage database, once I knocked them out I could delete the kjhg all together. I think it may help if I look at the screen a little more intensely. 8)


	IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Relationship prevents field deletion. Reply #5 - Aug 15^th, 2005 at 2:05pm	Print Post
	Since you can have multiple forms in Sesame, deleting an element from a form does not automatically delete the underlying field/information displayed in that element. You may be using that info elsewhere on other Forms or Reports. The only place to permanently delete a field is in Field Manager.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Pages: 1

‹ Previous Topic | Next Topic ›