dbTalk Databases Forums  

Filemaker 5.5 insert related row with values onclick

comp.databases.filemaker comp.databases.filemaker


Discuss Filemaker 5.5 insert related row with values onclick in the comp.databases.filemaker forum.



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

Default Filemaker 5.5 insert related row with values onclick - 02-15-2007 , 05:11 PM






Hello,

I have a simple relationship setup in filemaker 5.5. When I click a
button I want to Insert a new row into the relationship and insert
values from other fields into the new related row... Is this possible?
I don't see how to do this...Can you execute a sql insert statement
with filemaker 5.5? That'd solve all my problems.

Something like "Insert into filemakerfile.fp5 ( field1, field2) values
( 'value1', 'value2)"

Any help? Greatly appreciated.

-Watso


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

Default Re: Filemaker 5.5 insert related row with values onclick - 02-15-2007 , 05:46 PM






===SCRIPT START===
Go to Portal Row [ Last, Select entire contents ]
Set Field [ worklog::Employee, worklog::Employee="Joe" ]
Set Field [ worklog::Work Description, worklog::Work
Description="Administrative" ]
Set Field [ worklog::Hours, worklog::Hours=.25 ]
===SCRIPT END===

This solution was found here:

http://groups.google.com/group/comp....44262ecf6b81f4

Sorry, I had search for awhile looking for the answer. Didn't find it.
Posted here. But then found this after.


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.