updating order form

[kabir_hussein]

Hi

Does anyone know of a way you can update a table and save the values of the changes. i have a order form where users order goods, if changes are made to the order later i have deicded to use another table called change. however this is not working as good as i hoped and was hoping some one could give me some tips on a way of overcoming this problem

many thanks in advance

 

[rube]

More Information

Are there pieces in particular you want to record, or just every single item?

You could have another table altogether that uses the PK off of the original table. You could then use a subform, or another form (i.e. frmChange), that draws the PK off of the original, along with all the original data, in essence taking a snapshot of the original values.

You could have a "change" button that opens this Change form, and pulls the info with the date, then an undo/save to cancel/proceed with the changes allowing the original form to be edited.

This is one thought...

Rube

 

[kabir_hussein]

Hi

Thank you for your reply, what i wanted to get from the tables is price differences, quantity differeces etc.

i do like the sound of the change form where i could use a button that would move the data from one table to another however i do not know how to do that.

i have attached a screen shot of ER diagram, i am trying to link up my change table with my tenderlink table (changeID <> changeID) this is because one change can affect many items therefore the user wants a change number linked to all items made by one change. However when i link the change table with the tenderlink table and try view the current data in the tenderlink table its appears to be blank.

 

[kabir_hussein]

attachment

sorry didnt attach for some reason, i have sent a msg to web master to help me on this

 

[rube]

Quick Solution

One thing you could do quickley is just copy the original table, tblProduct, tblProductChange, same with the form, frmProduct, frmProductChange (using whatever name). Then, just open the Product Change Form when the Change button is pressed. In the tblProductChange, Change the the PK, and make it just a number, on the frmProductChange form, set the default value to feed off of the loaded form (=forms![frmProduct]![ProductID].

Before you do this, make a one to many relationship. You can then make countless forms based off of the frmProductChange to show countless data bits that are useful etc.

Rube

 

[kabir_hussein]

thank you

Hi

thank you so much for your advice i didnt understand what you meant at first but then reading it more and more i understood what you meant and now have a logical way of fixing my problem

Once again many thanks

p.s do you know why i cant post any attachments by any chance

 

[rube]

Attachment

When you submit a post, there should be the option to attach it at the bottom, your file size may have been prohibitive. You might try to zip it next time.

Rube

 

[kabir_hussein]

attachment option

hi

there is a option to attach a a ttachment but when i do attach a zip file it doesnt seem to posted onto the forum

kabir

 

[rube]

Example

Here is an example I quickly threw together for you, hope it helps, I added a ChangeDate field, to record when the change took place. You would just need to add a call to open the form based on the PK criteria. I will try to add this as a zip file.

Rube

 

[kabir_hussein]

thanks

Hi

thank you very much i see what u mean however i tried this method yesterday and couldnt find a way of saving the default values in the change table therefore my report came out blank when i did it

do you now what i can do

thank you