Hmm, maybe I'm not explaining correctly.
101 Redwood Flooring .50 SF
102 Copinal Flooring .45 SF
102 Diagonal Flooring .35 SF
So, the BO is "Flooring" and the attributes are "ItemNumber", "ItemDDescription", "UnitPrice".
I need to be able to enter a bunch of these to create a Master item List that I can store away, refer to and fetch. I know that I can go to each item and edit individually in form view but what I need is to call the item in to a grid from the Master list by typing the item number, into a job and be able to edit the Unit Price, just for that job but not affect the Master list item at all.
We have this capability already with other programs. We can type in an item code, have the code display all of the attributes (or cells) of an item and we can click on say, the unit price cell and change it to whatever we want. We actually have a prompt appear that asks if we want to update the Master material price...with a choice of yes and no. If we answer yes, the master material price changes for all future fetches. If we answer no, then the item unit price is changed for just this job.
This is old stuff, we were doing this 40 years ago, there has got to be a way, right?
Thanks for all replies!