Jump to content

Item passed to a new database for a record


This topic is 6610 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a value list (pop-up with the 7 stages of our production). What I want the database to do is once you select 'a production stage' from the pop-up menu, is to copy that status to another database called "worktracking" with a date and time stamp (new line entry).

When the stage changes to the next stage (eg the user chooses the next stage from the first databases pop-up menu), I would like the event to be once again captured by the other database... at the end there should be a history of every step (every stage that was selected in the main database) so we can do tracking on the lifecycle of the job.

I not worried about the date/time stamping area... it is more - how do I get FileMaker to pass the pop-up menu change to the other database and get it to create a new record for every occurence change?

Please... if you can help.


Other database captures these results from the pop-up menu selection from the first database...

History for JobNo. 0001544

Job Entered 01/01/05

Job Allocated 02/01/05

Job OnHold 02/01/05

Job Rework 03/01/05

Job OnHold 04/01/05

Job Closed 05/01/05

Link to comment
Share on other sites

This topic is 6610 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.