Hi,

I am hoping someone can help me out with this caculation

I have a db with a number of different layouts. One is for xx part numbers and the other is for yy part numbers. I have a button that brings you to a list view layout of both part numbers, since these are both in the same db.

From here I want to let the user to be able to click on a details button which will redirect them to the part number selected ( and the key issue )have it be directed into the layout for that particular number

ie. in the list view you can:

-click the details button for part number xx-123

-have the calculation direct to the xx layout.

-and from there you can make changes to the record

So far I have tried to creat a script with a calculation within it, but nothing has panned out!

Any suggestions for what the script should look like? I have very little experience with caculations and as for scripts I usually just guess!

If [ Left( Part_ID, 2 ) = "xx" ]

That works great!

Thanks!!