Creating a transaction histroy database

[OffTheDeepEnd.com]

Here is the layout of my current Solution, I have an order form database and a transaction history database. Currently there is a relationship between the two based off of the invoice id. I created a portal in the order form database so it would display all credit card transactions for that one invoice. That works just fine. The next step I am taking to is so that way the user can create a transaction in order form under the transaction portal and then have it authorize the credit card. Authorization is performed by running a script in the Transaction database. I created a button in the portal in the order form databse to run the external authorization script in the transaction database. The only problem though is, I am having trouble specifying which record to authorize in the Transaction Database. For example, if there is three transactions under one invoice, and I create a new one using the portal, instead of authorizing the new one, it will rebill the second transaction. Is there a way to specify the record so that way it will perform the script on the correct record?

[Ugo DI LUCA]

Hi !

Sort your relationship by the Transaction# or whatever field you can use to have your relationship descending. Then the first would be the last..

[OffTheDeepEnd.com]

Ok, tried the sort option... It still will authorize the first record... here is the scenario in a little bit clearer description:

In the orders file I have a portal with the following records:

A00001 Billed $25

A00002 Credited $6

A00003 Pending $2

So in the Transactions File I have those records with more information such as the customers name, address, credit card # and such. What I want to do is authorize the amount in record A00003 by clicking a button in the portal. Right now if I click authorize button now, even if record A00003 is highlighted, it will authorize A00001 or A00002... Hopefully that clears it up some.

[Ugo DI LUCA]

Well, a sort on the relationship , making it Descending, should bring the last row to the first....

[OffTheDeepEnd.com]

It brought the last row first but it is still authorizing the, what would be the last row, now...I would have thought that it would have done the same but it didn't... any other ideas?

[Ugo DI LUCA]

How are you "bringing back" this ID.

A simple SetField[Related::Record_ID] would work instead of an external script.

[OffTheDeepEnd.com]

Not quite sure what you mean by "Bringing back" the ID. The record ID is a auto enter serial defined in the Transaction database. Also in order to authorize the credit card, there has to be an external script un because it is a scripted process defined in the Transaction daatabase.

[Ugo DI LUCA]

Yes, OK

Say Main.fp5 and Related.fp5

A portal in Main with records from Related

A relationship sorted descending on the Related Ids

In Main

Set Field[g_Record_ID:Related::Record_ID]

PerformExternal

Where first part of External Script could be

SeField[g_ID, ::Main:g_Record_ID]

GoToRelatedRecord[g_ID::Record_ID]

A little bit of a guess here though.

[Ugo DI LUCA]

Hmmm...forget last post

GoToRelatedRecord[Related-show only]

PerformExternal

`where ExternalScript starts with :

GoToRecord[Last] or [First] according to the sort order of Relationship "Related"

[OffTheDeepEnd.com]

ok... I got the first part... but then the g_id... is that a field that I need to create? and then in the go to related record... I don't understand the "g_ID::Record_ID"

[OffTheDeepEnd.com]

ok... let me try that

[OffTheDeepEnd.com]

It worked! Thanks again!