Updating records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is the best method to update a table from a vendor? I have built a DB
for payments & need to bring in the most recent data. I would like to keep
the existing customer records, change only the payment records, & bring in
any new customers.
 
You haven't described your table structure, nor the table(s) provided by the
vendor.

A well-normalized data structure should allow you to have customer records
independent of any payment records.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
the vendor table was just the basic name, addr, ssn, & plancode. I have it
separate from the payment table, primary key is SSN on both. Also have a
dependents table (to store spouse & children names & DOB) the latter 2
tables are being populated manually.

I will not be getting a new vendor record. Basically, I have a copy of my
db which I'm "tweaking" while the payments are being added on the main db.
Any new data would be what is being added while I'm working on making the db
enhancements. (creating reports, etc.) I would like to be able to update
the tables in the newer version of the db then copy it to the network so it
can be the working db. does that make sense?
 
I'm not clear on how this relates to your earlier post.

If you have a database in which you keep up-to-date records, why copy it to
anywhere? Couldn't you keep that up-to-date database on the network, so all
who need to can see it?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
due to time constraints, the working db is a work in progress....after I get
other parts of it working, I'd like to update the database but keep the new
records that have been manually updated with payments.... does this make
sense?
 
Sorry to be dense. I'm not tracking on the overall "flow" - who gets what
when how.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

show the most recent payment 5
Query to pull all records for those missing records 5
Selection of records from subform to lock and further processing in access 2007 0
Force a query to populate consecutive dates? 3
How do I find the last record ? 5
Select and updates records based on previous record selections 2
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
retrieving most recent date using SQL 2

Back
Top