Using External Scripts

[Horatio77]

Hello, I'm new here, let me know if this question is out of place.

My company has an order tracking database. I don't use much of it, except its 'Time Tracking' table, which has an interface poorly suited to my needs. I've been given permission to create a separate database to design my own interface as long as it adds little to no extra work for the DB admin. My DB will have no real data, it's just an external window to 'Time Tracking'.

'ORDERS' has a script, 'Submit Time', that adds billing codes and costs which are updated occasionally by the admin. I would like to execute that script from a portal in my database. I have gotten half way there with a script that jumps to 'Time Tracking' and back again, but I'm not happy with it;

Go to Related Record [show only related records; From Table: "Time Tracking" ; External; Using layout: "Enter Time & Notes" (Time Tracking); New Window]

Perform Script ["Submit Time" from file: "ORDERS"]

Close Window [Name: "Snap Pop"]

This script works but has three clear problems:

• 1) A new window flashes across the screen
• 2)If any fields in my portal are active at execution, the script throws 'In Use' errors
  
• 3) There is no unique record ID field in the 'Time Tracking' table, limiting some options
  

So my questions are:

• 1) Can I elegantly avoid flashing a new window?Perhaps by somehow:
  
• 1b) Executing an external script through a local layout?
  
• 1c) Executing an external script in a hidden window without bringing it forward?

• 2) What's the best way to exit an active field in a portal, but keep the row active?
  
• 3) Is a lack of unique record ID actually a problem?
  
• 4) Am I going about this all wrong?
  

My hands are pretty tied on the 'ORDERS' side of things. I appreciate any thoughts you have.

-Max

Edited March 30, 2009 by Guest