Append verses Update Query

[Guest]

I have a query that dispalays all my info needed form the linked sql tables. I have three user fileds that will added by the user. I going to have to hold them in a seperate table. I need to field a way to relate the two sets of data. I was thinking Purchase order number would do it. I wrote a query that shows all info plus the three user fields. Is it best to use a append or update query. I want the table to always be updated or added to with new info such as when new p.o are added to the sql table or when info changes in the user enter fields. Any advice on this one.

 

[Albert D. Kallal]

It is not all clear here why you even need a query?

You can't possibility think that an application is going to be run by
directly editing tables (or queries)?

You need to create a nice form. For the field used in the relation...just
use the autonumber field (the user will never see, know..or have to worry
about this number anyway).

To deal with two tables on the same form..you use what is called a sub-form.
So, those "child" or so called related records can be added for you
automatically if you use a sub-form (and, ms-access will kindly put in the
correct values in the field used to maintain the relation for you). All of
this can be done without any queries..and in fact not even any code need to
be written.

So, you can't even begin to start building an application and assume that
users will someone know what query, or table to open. Give them a nice easy
to use form that loads...and then anyone can user your application. The
result is something easy for your users..and for you the developer...you
don't have to write any append, or update queries...as ms-access will do all
the work for you.

You can read about using sub-fomrs here:

http://www.attcanada.net/~kallal.msn/Articles/fog0000000005.html