Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Odbc Linked Table From Quickbooks
Ryan Harrison 
   
8 months ago
I am bringing my customer list into Access via an ODBC linked table to access. When this table comes in, QuickBooks has already assigned a CustomerID, ShipAddrID, BillAddrID, and ParentRefID for any sub-customers. The IDs assigned by QuickBooks are short text and I'm not sure if it's important to get IDs in an auto-number format. Is it best practice to import this linked table into a local Access table to work with within the database? Or should I just set my relationships through the linked table?
Sami Shamma  @Reply  
             
8 months ago
It depends on what you do and what other information you are bringing from QuickBooks.
For example, you have:
- The shipping address
- The billing address
- The parent reference that you have the IDs for

If you do, then you can use those. Otherwise, you may want to import them first.
Richard Rost  @Reply  
          
8 months ago
If you are just syncing the data with QuickBooks, in other words, you're opening up a connection to your QuickBooks data and then importing any new data or changed data into your database, then I would keep QuickBooks' ID and just assign your own autonumber to each person in your table, but store theirs as a reference. That way, every time you do an import, it just matches them up by the QuickBooks ID and then updates the record accordingly.

If you're working with a live copy to their ODBC source, then I would just say the best thing to do is just go with their ID. Otherwise, it's going to be crazy keeping track of all that.

You could set up a hybrid solution where in your database you literally have a table that's just the autonumber you assign to each customer and their QuickBooks ID, and that's all that's in that table. That way, when you connect to the customer through QuickBooks, you know what your autonumber is by referencing everything together. So your relationships would be: Your customer table, the cross-reference table, the QuickBooks ODBC table. But that's a lot of work.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 6/20/2026 9:21:26 PM. PLT: 1s