Atlanta Macintosh Users Group
September 01, 2007, 07:37:01 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: AMUG would like your ideas for future General Meetings. Please go here and give your feedback!
 
   Home   WebHome Search Calendar Chat Gallery Login Join AMUG Help  
Pages: [1]   Go Down
  Print  
Author Topic: Scripting FMP find  (Read 54 times)
Larry Cronkite
Member
***
Offline Offline

Posts: 157


« on: August 16, 2007, 10:16:31 AM »

I am trying to set up a script that will show the corresponding inventory item when the find icon is clicked in the order window (repeating record).

I have been able to open the inventory window but I have not been able to find the correct setup in the Specify Find Requests panel to cause the inventory window to display the correct corresponding item.

When I set it up to find the inventory_productID = sales_productID I get an AND function - that doesn't work.

Can anyone help?
« Last Edit: August 16, 2007, 10:21:24 AM by Larry Cronkite » Logged
Lee Hoong
SIG Leaders
Apprentice
********
Offline Offline

Posts: 147



WWW
« Reply #1 on: August 18, 2007, 12:41:30 PM »

I am trying to set up a script that will show the corresponding inventory item when the find icon is clicked in the order window (repeating record).

I have been able to open the inventory window but I have not been able to find the correct setup in the Specify Find Requests panel to cause the inventory window to display the correct corresponding item.

When I set it up to find the inventory_productID = sales_productID I get an AND function - that doesn't work.

Can anyone help?


Larry,

If I understand you correctly, you're trying to hardwire the scripted find request by setting the find criteria via the Specify Find Requests dialog in ScriptMaker - that's not going to give you the flexibility you're looking for.  Your script should:

1. Capture the search criteria from the Sales screen (either via global fields, script parameters, or variables)

2. Go to the Inventory layout

3. Enter Find Mode

4. Populate the appropriate fields with the previously-captured search criteria

5. Perform Find

Hopefully, that was clear enough.

Lee.
Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC Valid XHTML 1.0! Valid CSS!