Thread View: comp.sys.mac.databases
2 messages
2 total messages
Started by David Remsen
Thu, 21 Jan 1993 14:31
FM Pro 2 - Updating files from files
Author: David Remsen
Date: Thu, 21 Jan 1993 14:31
Date: Thu, 21 Jan 1993 14:31
17 lines
1375 bytes
1375 bytes
We are trying to develop an accounting system for our Marine Resources Dept., a small internal department that ships out marine specimens. We would like to have several Filemaker files; a inventory/specimen file, and an invoice file. The invoice file can perform lookups from the specimen file to fill out ordered animals. Where I am stuck is that I would (ideally) like to be able to deduct from the inventory file when an animal is shipped on an invoice. In other words, if I put 2 animals on an invoice in the invoice file, it should be able to automatically deduct 2 from the inventory file. At present, the only way to do this is to manually open the inventory file and manually edit the field. Is there any way to automate this process? I guess the bottom line request is if there is any way to modify one filemaker file from within another? Any suggestions are most appreciated. David Remsen Marine Biological Laboratory
Re: FM Pro 2 - Updating files from files
Author: Brian Hughes
Date: Thu, 21 Jan 1993 15:59
Date: Thu, 21 Jan 1993 15:59
22 lines
1583 bytes
1583 bytes
dremsen@mbl.edu (David Remsen) writes:
>Is there any way to automate this process? I guess the bottom line
>request is if there is any way to modify one filemaker file from within
>another?
Well, you should be able to do it using Apple Events and have a
script in one file that opens the other file and performs a function. I
don't know how extensive you can be with the commands you want it to
process, but I do know that you could do this with Hypercard talking to
FM Pro using Apple Events. Take a look at the HC example that comes with
FM Pro 2.0.
--
-Brian V. Hughes
"December 1 - What begins as a friendly transitional get-together between
the Bushes and the Clintons ends in tragedy when Millie ralphs up what
--
-Brian V. Hughes
"December 1 - What begins as a friendly transitional get-together between
the Bushes and the Clintons ends in tragedy when Millie ralphs up what
is later identified as Socks the cat." Dave Barry 1992 Year in Review
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads