Results 1 to 3 of 3
  1. #1
    Wrangler is offline Wrangler
    Windows 7 Access 2007
    Join Date
    Dec 2005
    Location
    Alabama
    Posts
    17

    inport data into invoice from Purchase order database

    I have two database; one is a purchase order database and the other is invoice database. They both use the same product, employee, shipping and customer tables; the only tables that they do not share are their order and order detail tables.

    Most of the order data is the same with the acception of the invoice and purchase order numbers; what I would like to do is have a button bring the purchase orders over to the invoice database so I do not have to input all the data again.



    I was thinking an append query that would bring bring the order and order details over by date but how do I do it so that the order numbers will match.

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    Why not just import the relevant tables?

  3. #3
    Wrangler is offline Wrangler
    Windows 7 Access 2007
    Join Date
    Dec 2005
    Location
    Alabama
    Posts
    17

    Coverting Purchase Orders to invoice

    What I would like to do is just bring the new Purchase Orders to the invoice side: nightly.

    Each need to maintain their own tables, so importing the tables I do not think will work; thats why I was wondering is an append querey would work. :?:

    Thanks

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 02-13-2008, 09:55 AM
  2. Duplicating lines in an invoice report
    By GordonEdinburgh in forum Forms
    Replies: 0
    Last Post: 04-21-2007, 12:20 PM
  3. Replies: 0
    Last Post: 12-11-2006, 04:55 PM
  4. Replies: 2
    Last Post: 07-24-2006, 09:19 PM
  5. How to report data in fical year order
    By gemini2 in forum Reports
    Replies: 1
    Last Post: 05-27-2006, 06:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums