(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Confused Please Help
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Hot Topic (More than 10 Replies) Confused Please Help (Read 1604 times)
billgordon
Junior Member
**
Offline


No personal text

Posts: 61
Joined: Dec 31st, 2003
Confused Please Help
Jun 16th, 2005 at 7:42pm
Print Post Print Post  
I am so confused, again!

If I have a form with subforms can I search from the subforms?

I have a main form that has firm name and it has naturally linked subform to contacts.

I enter firm name and then enter contact info (1 to many) from the main form.

When I try to search an element that is on the subform (like contact name) It does not retrieve anything.
  
Back to top
 
IP Logged
 
billgordon
Junior Member
**
Offline


No personal text

Posts: 61
Joined: Dec 31st, 2003
Re: Confused Please Help
Reply #1 - Jun 16th, 2005 at 10:05pm
Print Post Print Post  
An Example that leads to my Confusion is using the sample database countries you can not search using cities subform, However

Using the sample database gems you can search from the gems subform.

Both subforms look to be created exactly the same.
  
Back to top
 
IP Logged
 
Boneyard_Scrounger
Junior Member
**
Offline


Canadian Government =
Elected Dictatorship

Posts: 88
Location: Peoples Republic of Kanada
Joined: Apr 20th, 2005
Re: Confused Please Help
Reply #2 - Jun 17th, 2005 at 11:31am
Print Post Print Post  
I was about to post a similar question, except that I use relational links. In my case, the search is unending. It simply says 'working' apparently forever, or until I force Sesame to close. I'll be watching the thread.

Given the nature of subform searches, I'm not sure that they will be of a lot of use in our aplication anyway, but I wouldn't want it locking the system when someone trys it.
  
Back to top
WWW WWW  
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Confused Please Help
Reply #3 - Jun 17th, 2005 at 12:03pm
Print Post Print Post  
This may be your problem?

I just tried searching for a city from within the country main form. It works, but you may need to either move focus to the main form before pressing F10, or press F10 twice to get the search going.

The cities subform is a table-view subform rather than a form-view subform. I find that the table-view subforms are a little funky in the way focus works. Sometimes it is just highlighted by a dark gray color, and sometimes the element actually will have the cursor in it.
  

Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
WWW WWW  
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Confused Please Help
Reply #4 - Jun 17th, 2005 at 12:10pm
Print Post Print Post  
Quote:
I was about to post a similar question, except that I use relational links. In my case, the search is unending. It simply says 'working' apparently forever, or until I force Sesame to close.

Relational links are MUCH SLOWER than natural links. It might just be that Sesame is really "working". If at all possible, you should try to use natural links. Not only for speed, but also because it will reduce the programming overhead required by you.

  

Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
WWW WWW  
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Confused Please Help
Reply #5 - Jun 17th, 2005 at 12:47pm
Print Post Print Post  
Quote:
An Example that leads to my Confusion is using the sample database countries you can not search using cities subform, However

Using the sample database gems you can search from the gems subform.

Both subforms look to be created exactly the same.


I can search using the Countries' cities subform - without problem. For example - type "a.." in the search spec for City, and I get all of the parent forms that have a City that starts with "a".

Remember, searching on a child form returns any parent that has a child that matches the spec. It does not "filter" the children - it returns the parent that matches - as though the child form/table was a set of LEs embedded on the parent (as they are).
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
BOBSCOTT
Senior Member
Members
*****
Offline


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
Re: Confused Please Help
Reply #6 - Jun 17th, 2005 at 2:02pm
Print Post Print Post  
Quote:
I find that the table-view subforms are a little funky in the way focus works. Sometimes it is just highlighted by a dark gray color, and sometimes the element actually will have the cursor in it.


Bill,

Carl is correct about the focus issue with table view subforms.

If it is the same app you have been working on with the nested subforms (subforms on subforms on multiple tabs) it really gets a little finicky. Be careful with the use of FormCommit("") command you are using from your main menu as a save button because it really behaves funky with the nested subforms, probably also because of focus as carl points out.
  
Team – Together Everyone Achieves More
Back to top
 
IP Logged
 
Boneyard_Scrounger
Junior Member
**
Offline


Canadian Government =
Elected Dictatorship

Posts: 88
Location: Peoples Republic of Kanada
Joined: Apr 20th, 2005
Re: Confused Please Help
Reply #7 - Jun 17th, 2005 at 11:38pm
Print Post Print Post  
Quote:
Relational links are MUCH SLOWER than natural links. It might just be that Sesame is really "working". If at all possible, you should try to use natural links. Not only for speed, but also because it will reduce the programming overhead required by you.



I guess I'm afraid of natural links.
I run a cemetery, and the data must be absolutely accurate. There is really only one LE that links the forms absolutely, but I'm afraid of getting someone in the wrong grave basically, if I switch to natural links.
Am I wrong in thinnking that?
Ray might know, as he has seen two of the forms.
  
Back to top
WWW WWW  
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Confused Please Help
Reply #8 - Jun 18th, 2005 at 12:09am
Print Post Print Post  
I also was fearful of natural links.  But the difference in speed was so great, that I have been forced into it.  But I can have the best of both by putting a Parent ID "index key" field in every sub form record. 

For example, every Sales Order Line Item (natural linked sub form) has a mandatory Read Only field for the Sales Order Number also.  This field is filled when the sub record is added, getting the Sales Order Number from the Parnet Form.  Can be made Invisible except when doing a Retrieve Spec.

This gives me the ability to do XLUs in the sub form using the ID Key (Sales Order Number) for the Parent Form.  Can also do an XLU for all items associated with the Parent form (Sales Orders).

Also allows me to purge any Orphan records in sub form that do not have a Parent Form for some reason.
  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Confused Please Help
Reply #9 - Jun 18th, 2005 at 5:32pm
Print Post Print Post  
Quote:
...I can have the best of both by putting a Parent ID "index key" field in every sub form record.

That's exactly what I do too. It works very well.

I also was afraid to rely on natural linking. That's why I put a key field in the subform records. In case natural linking "blew a gasket", I would still know what parent form the subform records belonged to.
« Last Edit: Jun 19th, 2005 at 1:05pm by Carl Underwood »  

Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
WWW WWW  
IP Logged
 
Boneyard_Scrounger
Junior Member
**
Offline


Canadian Government =
Elected Dictatorship

Posts: 88
Location: Peoples Republic of Kanada
Joined: Apr 20th, 2005
Re: Confused Please Help
Reply #10 - Jun 20th, 2005 at 8:25pm
Print Post Print Post  
I made a copy of the aplication to 'play with'.
But, I can't remember how to switch between relational and natural links.
How do I bring up the window that allows me to switch?
Can't find it in the manual.

By the way, the new manuals are great, well worth the $.
  
Back to top
WWW WWW  
IP Logged
 
BOBSCOTT
Senior Member
Members
*****
Offline


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
Re: Confused Please Help
Reply #11 - Jun 20th, 2005 at 8:58pm
Print Post Print Post  
To change subform settings you would go to the form that contains  the subform element and right click on subform element and choose subform settings, However I believe you can not change the link style. You need to remake the subform element.
  
Team – Together Everyone Achieves More
Back to top
 
IP Logged
 
Boneyard_Scrounger
Junior Member
**
Offline


Canadian Government =
Elected Dictatorship

Posts: 88
Location: Peoples Republic of Kanada
Joined: Apr 20th, 2005
Re: Confused Please Help
Reply #12 - Jun 21st, 2005 at 11:07am
Print Post Print Post  
Thanks Bob.
If that's the case, as I retire on Friday, I'll leave that to the next guy.  Grin
  
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge