simple update query

[fishhead]

Hi i'm having trouble getting my head around the proper way to create/update a record.

I used to create two forms (form 1 would have part of the data that i wanted to update in form 2)

Now what i would like to do is use the update query feature to do this but i'm not sure how to set this up.


qSupplierPymtTerms returns 4 fields - 2 of which have data i want to use
field :autonumber
field : credit terms

qAPPaymentDates has 4 fields - 2 of which i will be updating by qSupplierPymtTerms

qAPPaymentDates is an update query
first question. How do i update a new record only ? I don't want to update all the other records in this query?

Once this is sorted out i want to update qAPPaymentDates query as follows:
FIELD qAppaymentDates[AP Costs Autonumber] update to qSupplierPymtTerms[autonumber]
FIELD qAPPaymentdates[AP Paid Date] update to Date()+qSupplierPymtTerms[Credit Terms]

Can someone please point me in the right direction?

thanks in advance

[Micron]

Terminology - a new record is one that hasn't been finished yet. In fact, it may not even have been started. You append new records; you update existing ones. You really can't update a new record. If by that you mean one that you've just created, then it's not a new record - it has the same "newness" as any other record. It might be distinguishable based on a create date/time, or many developers might rely on the greatest autonumber id to tell then which is the latest record.

So if this isn't what you're needing, then the reason is because of my misunderstanding of the terms you used...
You prevent updating of all existing records by providing criteria in the query that will restrict the records, and if possible, you join the two tables on a common field where at least one of them is unique. Since I can't see the tables, nor did you specify what the 4 fields are in the 2nd query, that's the best I can offer for now; except to say, experiment on table copies.

[orange]

I agree with Micron's comments. As he said, there may be some terminology/concept issues. It might be helpful if you could give us an example in plain English showing some values in the various tables, and what the intended final result should be. Remember, we don't know your application nor database design, so samples or specific uery SQL and table designs will help communications.
Good luck.

[fishhead]

Thanks for the feedback. let me review this more accurately.