Continuous Forms After Update Event

[Perceptus]

I am looking for an event that occurs with after update of a continuous forms form. Ive googled and found slightly relevant information about On Current.



But I can't seem to find a object set to the scope of the previous record.

What can I do?

[June7]

Exactly what are you trying to accomplish?

[Perceptus]

The combobox is a status combobox with text values in the continuous form. when that combobox is changed. I wish to update another table after the record is saved.

[June7]

And what does that have to do with 'previous record'?

Sounds like a simple UPDATE sql action. Why is data in another table dependent on this combobox value? Saving dependent data is usually not good design.

[Perceptus]

Mainly this is an attempt to create a system to track the status of orders, without having to change the table structure of the orders. changing the structure of the table just isn't a good idea atm. So I was trying to create an associate foreign key between the order table and the work orders table on the fly.

This works.

the work orders table only shows data that has a certain status value. When a status is changed from the order table, i want it to update an additional field that tracks whether or not an item appears to users on the work order table.

[June7]

Not much of that makes sense to me.

AFAIK, INNER does not have left or right.

[Perceptus]

It may be as simple as an update sql action. I think I can make an update query to handle this based on the associate foreign key.

Thank you for your thoughts =).