Using Paste from a Script to Find a Record

[gregorj]

This one has me sucking my thumb!

I have a situation where I need to COPY a five digit field (CustID) in Transaction Layout. Then, Goto (Member Layout::Member Table). Enter find mode, select (CustID) field and PASTE. Then Perform Find. Problem is, it won't paste from the script!

It will paste if I stop the script just before the paste step and manually paste the characters, so the copy part of the script works just fine.

This however does not help because everything in this solution is scripted because it is in Kiosk Mode and no keyboard exists.

Whats even stranger is that there is another case where the user needs to Copy/Paste the same characters but rather than Pasting the result into a find field, a New Record is requested. The paste function works just fine in this case. Exactly the same syntax other than going into find mode.

I don't necessarily need to use Copy/Paste if there is another way to accomplish the task. I'm trying too determine whether this 5 digit ID number already exists in the member database. I have tried to use Set Field with no success but that may be because I have the syntax screwed-up,

Please help.

Greg Jones

[bcooney]

How about Go To Related Record (GTRR) from Transaction to Customer?

[gregorj]

Thanks for the prompt answer. I've looked at GTRR but I can't get it to work in this case. Let me flesh out the logic a little further.

This is a golf course POS solution. The cashier has a Touch Screen with a hand scanner. A member usually shows a Member Card with a bar code. This is scanned in and the members vital statistics shows on the screen and starts the fees procedure. This has all been worked out.

The solution I need is when a so-called member claims that they

"forgot" their membership card but they memorized their 5 digit number.

We have a field that displays the unique number when it is scanned in or it can be entered manually in the same field (member_ID) This is on the transactions layout.

In order to check to see if the number submitted is in fact a valid member number, we need to access another table called Members. We then need to determine if the number is actually in the Members database. If it is not found then the cashier will see a message that the number is not valid, etc. etc.

If I could get Copy/Paste to work, it is a simple solution. I get lost in GTRR as it relates to this application.

Thanks again,

Greg

[bcooney]

If they enter an invalid number, the transaction can't show the related member info. Doesn't that give you enough info to let you know that that member id doesn't exist?

Or, have the cashier click a "Doesn't have card" button. This button goes to a Member layout in find mode and waits. Cashier keys in the ID or the last name and phone and clicks Perform Find.

If it finds, show found set. Have button to create transaction on each row of the found set list view.

[gregorj]

Sorry for the delay in gettting back to you...I was away. Your solution really helped.

Thanks a lot.

Greg