Hi Carl,
Sorry ... I was tired and typed from memory, not cutting and pasting.
Okay, so attempt two ... I created the following (pasted) global code in my customer screen:
//
IgnoreKey(KEYCODE_F3,0)
===========================================
// Look Up User Restrictions -- BW 2012-08-25
// ===========================================
gStaffLimit = (@Xlookupsourcelist(@FN, @userid, "Staff Screen!StaffRef", "StaffLimitBranch;StaffLimitClt;StaffLimitUser"))
I then tried the following on Retrieve Spec Open (which didn't work):
if @accessstringarray(gStaffLimit,1) <> ""
{
DBBranch = @accessstringarray(gStaffLimit,1)
}
if @accessstringarray(gStaffLimit,2) <> ""
{
DBCltNo = @accessstringarray(gStaffLimit,2)
}
if @accessstringarray(gStaffLimit,3) <> ""
{
DBColl# = @accessstringarray(gStaffLimit,3)
}
And then to keep pesky staff from altering those fields, I created a code on element entry (again, didn't work):
if @accessstringarray(gStaffLimit,3) <> "" then Throwfocus(DBNote0)
So, the problem seems to be I can't limit or control what is happening in the Search Screen ... I can populate elements, but I can't restrict navigation or alteration of what I have inserting ... help?