Updating values on Table

[kabir_hussein]

Hi i have three tables(see attachment) which help make the Part table list. The Supplier table gives the best price a item should be sold for, this is then defaulted to the Part table as the price to sell. The supplier table also has a percentage increase field where if the percentage is increased the price to sell increases.

However if this takes place a price increase must occur on the part table. Does anyone know how i can do this.


Also does anyone know how if a field has the control field set another field, when you save it, it does not save on the original table. Does anyone know how i can over come this.

Many thanks, all help is appreciated

kabir

 

[kabir_hussein]

Hi many thanks for the reply, I realise the field is not bound to the table hence it does not save to the table when clicking in save. But the field gets its data from another field in the subform.

I was wondering is there a way the field could save the data, so it can be used elsewhere.

I have attached a picture of what i mean, many thanks for your help


regards

kabir