Its an OrderEntry thing//

I have a parent ORDER, with 1 child ORDERITEMS that gets its info from 2 child INVENTORY file

All the items in my ORderItem file accrue so I can run reports of Posted items

When operator checks out buyer, they select MAIN Description using list.. then they select the 2nd List or 'thePackage' ..Now, its depending on package to find the cost and stuffing it to Cost field..

Operator finishes then enters the QTY and it subtotals

Can't figure for life of me.... how to get COST field to fill in when selecting the Package??

My sample attached code uses a zippscript to in the Package field and trigger that says "Hello" currently.. and right after operator selects "PACKAGE" ..

Testing use Viewer to inspect Inventory data its BLANK!! Even the relation field in orderItem record field is when recorded is added blank.. Its suppose to get the orderNo from Inventory

What I figure as the problem is my relation to inventory

When I click portal it adds a record... and my keyfield INVENTORYNO gets stuffed from the Inventory file..

ITS NOT DOING SO inspecting OrderItems its blank

Thats another weird thing.. I rather it not act that ways and have button calling a script to add portal record...at least, that way i don't det extra line.. it eliminate the extra possible lines printout too and in the portal.

Another support person said I don't need triggers

( am using FM 9pro Adv )

Same kind of situation for discount... want to put list saying "None, Senior, Verteran, spec1, spec2 etc " and it calc to percentages

Any help is grateful I advance

Sorry, i make it so complicated... I am learning.. but this one got to me over a week.. its actually last item to finish.. I can work around.. calc all my 5 packages "$ cost in one text line.. and display it across the screen so the operator can manually enter it.. klutzy

sept14-RodM.ZIP

Edited September 15, 200916 yr by Guest

From your file: "For each OrderItems... record How do I get the InventoryNo in the OrderItems.."

You have it backwards.

You ENTER the inventory number - first.

Everything else gets looked up from that.

GrabPortalData.fp7.zip

Edited September 17, 200916 yr by Guest

Sorry thanks taking your time for reply..

Your clue-1 I was told something like that.. and I still don't get it? My operators don't know the inventory #

They first look up by Type,, then by Product that fill in the Cost field?

I get that if I was at the right #inventory, then all the relationship might be in line.. and viewer with vars.

but

I am wondering adding in OtherItems portal record...

How is the ID, key relation field filled in?

Its blank

A spark went off...

Are you saying something like create a list on my ID, use 2 fields, the Id# sort and my description field.. Sort-on and show the Description field?

I screwed with that w/o success...I think i recall you can select a 2nd var and there some sort and display options.. that didn't work.

I will go back there again..

I am sorry.. I tried.. seemed to work.. But selected Descr Pull down for Type Cat, then select Package, it add a new record to the global duplicates the descr field to the 2nd rec... and erases the descr field in the 1st record.

Can someone make my zip work.. I got to see it

Give me your PayPal# small donation lots of gratitude.

Sorry thanks taking your time for reply..

Your clue-1 I was told something like that.. and I still don't get it? My operators don't know the inventory #

Then you're going to have to show it to them. You're going to have to present a product-picker list.

'''????'''