Getting out of relation or extra records 2nd picklist..

[RodM]

I upload a jpg this one 290K... can't remember if it take a while for apporval... then uploaded again... same error here ?

First, thanks again to everyone answering our sometimes stupid, unclear questions... even trying to explain some of this.. Your amazing

I am in this project after running out of money paying programmers and loosing income in this economy... but stuck to finish this somehow.. and because of this... i am learning a whole lot.. but not enough sometime.. FM certainly has some strange ways..

5 days.. 9am to midnight straight.. and close...

When adding portal records of different kinds of inventory my valuelist from selected fields mixing up

I have 1 file... with several tables in it...

Picklist.. drop downs using valuelist

I don't think this is a valuelist problems since it works until i add a different inventory #

I have attached 1 image with all my relations, and my ValueList. and my PackPicklist table

Kind of a POS thing..

I have 2 valuelist in the Parent Layout ..outside of the OrderItems portal in the layout.

1) Picklist valuelist for Inventory locating on a tabels fields in Product Inventory.

.. Works fine... I get ice cream vanilla, choc & strawberry

and the 2) other PickList for SizePackage Small, Medium Large

At POS, I can add more records Inventory to OrderItems (my sort of checkout sales)

AND ONLY if of the the same Kind of Inventory having EXACT SAME selection in picklist

Everything seems to work until I add another DIFFERENT Inventory item Package selections or picklist seems to append other items that are a different Inventory number......of record to OrderItems

if I choose adding different inventory item to my OrderItem tabel

, say Apples, with SizePackage Delicious, Johnathen, Fuji

Then my PackagePickList shows all Vanilla, Choc, Strawberry, Delicious, Johnathen, Fuji mixed??

My Table View shows okay all my records

A table of the PackagePicklist SizePack valueListing ......shows the accumulation of both mixing apples with ice cream SizePackage 2nd valuelist choices

Parent file MessageAccount fieldname msg_id

related to table OrderItems fieldname order_msg_id (that is in a Portal in the layout)

related to table Inventory fieldname Product_InventoryNo

related to table Package fieldname_package_invNo

InvNo package picklist something like this... and spelling is consistent cases too

InvNo Type Select

---------------------------------------------------------------------

200 apples Delicious

apples Johanthen

apples Fuji

----------------------------------------------------------------------

300 IceCream Choc

ice cream strawberry

icre cream vanilla

-------------------------------------------------------------------------

I am using ziff triggers in my calculation fields that let me setup things... I am running fm9pro

Both valuelist fields are text with calculations using those Ziff triggers the select pick as a Parameter to a script

My PackagePicklist tabel.. previewing it has no duplicates with the same InventoryNo

Edited January 21, 2010 by Guest
uploaded file... click got error up loaded it again... same? Photoshot ested it ok?

[efen]

Er... is there a question in there somewhere?

[RodM]

I decided to hire one of the FM guy hanging here... even donate to the forum

I was burnt out.. newbie

the question is... whats wrong with my design or what...

Later i will answer that..