dbTalk Databases Forums  

Filemaker 7, portals & set field

comp.databases.filemaker comp.databases.filemaker


Discuss Filemaker 7, portals & set field in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Andy
 
Posts: n/a

Default Filemaker 7, portals & set field - 10-20-2005 , 10:04 AM






Hi again,

I've narrowed down the problem we are having with FM7 after an upgrade.

The problem seems to be this:

We have a portal on a form, and a button on the form which ends up
doing a Set Field to the table whose data is shown in the portal. In
version 6, this works fine, but in version 7, the row is created in the
related table, but it never shows up in the portal.

Then, when you try to leave the main record, you get an error because
another field in the portal record is required Not Empty, but since you
can't see the row you can't enter the data or delete the row.

A refresh window doesn't seem to help.

Any ideas?

Thanks
Andy


Reply With Quote
  #2  
Old   
FP
 
Posts: n/a

Default Re: Filemaker 7, portals & set field - 10-20-2005 , 11:39 PM






Does the refresh window with "Flush cached join results" checked work?
Can you set the field by script, commit the record with "Skip Data
Entry Validation" checked, then go to the portal row and put the cursor
in the record so the user still has to fill in the required field?


Reply With Quote
  #3  
Old   
Andy
 
Posts: n/a

Default Re: Filemaker 7, portals & set field - 10-21-2005 , 11:56 AM



Flushing the join results doesn't help, although I didn't think of that
second procedure.

I'll give it a shot; as a temporary fix, i just stopped it from
creating the row automatically.

Thanks!
Andy


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.