Solved

Filemaker pro 11 Scripting Portal

Posted on 2011-02-22
1
564 Views
Last Modified: 2012-08-13
I have a database (see attached) that has two tables (ProjectDetails and ProjectArchive). I have created a portal using the ProjectDetails as the source. What I want to do is be able to move (copy into) the records into the ProjectArchive table once the 'Archive' field is set to 'Yes' in a particular record. I have created a script ('Set Reset Archive') that allows the user to click on the 'Archive' field and this script will change between the values  'Yes' or 'No' (1 or 0). I basically want to append the particular record into the ProjectArchive table leaving the original record under the ProjectDetails Table.
Thanks.
Project--Archiving.fp7
0
Comment
Question by:PachecoPrimo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 12

Accepted Solution

by:
North2Alaska earned 500 total points
ID: 34958041
Once the record has been archived what will you do with the original record?  Can it be archived again?  When the Archive is complete will you switch the value back to No?

I'm wondering if there isn't a better way of presenting this.  Maybe with a button?  

I've made a couple of modifications to the script.  See if they are what you are looking for...
Project--Archiving.fp7
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question