Automatically adding information onto a form

[Guest]

my system is for meat distribution. i want to make a form so that for each
peace of meat that is ordered the information of the person who order's it is
updated everytime an order is confirmed.

how would i go about doing this ?

do i use an update query??

 

[Joseph Meehan]

my system is for meat distribution. i want to make a form so that
for each peace of meat that is ordered the information of the person
who order's it is updated everytime an order is confirmed.

how would i go about doing this ?

do i use an update query??

Maybe, maybe not. It depends on how your tables are designed and how
you will collect the additional-new information.

I would think that rather then collecting the information each time an
order is made, it would be better to check the information and update it if
needed for each new order. That would save a lot of time. Generally you
could present the data entry person with the current information on record
and it could be changed at that time. A lot of what you do would depend on
the trust you have in the people doing data entry and how often the
information changes etc.