I have a form that allows users to display/filter a 3 field table (Product, Part No, Qty) The problem is the default form allows users to inadvertently change the Product field and inadvertantly allocate the Part No to another Product, I need to make the first field filterable to allow the user to only see the cutting list of the one product but then only allow editing of the Part No or Qty Field. An example would be that product “A” has three parts 1000, 1002, & 1003 each has Qty 1 each. The user must be able to change say Part 1001 quantity to 2. Delete part 1003 and add a new part say part 1004 1off. Where would I put the restraints?
Any pointers would be most appreciated. Should i actually be looking at a query to do this.
TIA
Cliff
Any pointers would be most appreciated. Should i actually be looking at a query to do this.
TIA
Cliff