dbTalk Databases Forums  

'New Record' targeted to a specific table?

comp.databases.filemaker comp.databases.filemaker


Discuss 'New Record' targeted to a specific table? in the comp.databases.filemaker forum.



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

Default 'New Record' targeted to a specific table? - 04-03-2007 , 05:53 AM






Hi,

Is it possible to have 'New Record' targeted to a specific table,
instead of the one table associated with the current layout?

I have a layout with data mixed from two tables, as i think would be
common for a relational database, and I want to insert a new row into
one of the subordinate tables without switching to a layout where that
table is the primary table.

Possible in FM8.5?

thanks
woody


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

Default Re: 'New Record' targeted to a specific table? - 04-03-2007 , 07:28 AM






In article <1175597606.338840.325580 (AT) b75g2000hsg (DOT) googlegroups.com>,
"Woody" <gotwoody (AT) gmail (DOT) com> wrote:

Quote:
Hi,

Is it possible to have 'New Record' targeted to a specific table,
instead of the one table associated with the current layout?

I have a layout with data mixed from two tables, as i think would be
common for a relational database, and I want to insert a new row into
one of the subordinate tables without switching to a layout where that
table is the primary table.

Possible in FM8.5?

thanks
woody
Two ways:

Create the new record in a Portal to the related table. This is the
easiest way.

or

Write a script to do it. The script would switch to the related table
layout, create the new record, populate the fields as you specify, in
the script, then switch back again to the original layout. The switch of
layout would not be visible to the user unless you include a pause step
in the script.

--
For email, change <fake> to <earthlink>
Bill Collins


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.