Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-30-2017, 09:00 AM   #1
mreference
Newly Registered User
 
Join Date: Oct 2010
Posts: 128
Thanks: 14
Thanked 0 Times in 0 Posts
mreference is on a distinguished road
Temp Table with Two Outcomes

I have a temp table of skus that require ordering which has been generated from our sales records.

In this table, are the [Supplier Code], [SKU] and [Quantity].

I have a purchase order set-up, that consists of two tables, the header which stores the [Supplier Code], and the detail that stores the [SKU] and [QUANTITY].

Is it possible to use the information in the temp table to send the right information to the right table (header and detail)?

__________________
"To come second, means you're the first to come last"
mreference is offline   Reply With Quote
Old 01-30-2017, 09:28 AM   #2
Ranman256
Newly Registered User
 
Join Date: Apr 2015
Location: KY,USA
Posts: 3,367
Thanks: 0
Thanked 742 Times in 727 Posts
Ranman256 will become famous soon enough Ranman256 will become famous soon enough
Re: Temp Table with Two Outcomes

in your append query, use the BUILDER to pick the item on the form to add to the table.
usu:
forms!myForm!txtSuppCode
Ranman256 is offline   Reply With Quote
Old 01-30-2017, 02:20 PM   #3
mreference
Newly Registered User
 
Join Date: Oct 2010
Posts: 128
Thanks: 14
Thanked 0 Times in 0 Posts
mreference is on a distinguished road
Re: Temp Table with Two Outcomes

Thank you for your answer, I'm not sure how that works. Are you saying I need to create a query/form with all the data from the temp table, then use the builder to take out the supplier code and put it in the header table, then put the remaining two fields into the detail table?

Could you possibly expand your reply to show me how it works?

-----

Field A = Supplier_ID - this needs to goto table_purchaseorderheader

Field B = SKU_ID
Field C = QTY - these both to table_purchaseorderdetail

__________________
"To come second, means you're the first to come last"
mreference is offline   Reply With Quote
Reply

Tags
split , table , temp table

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Looping through Recordsets with multiple outcomes RSC Modules & VBA 4 04-24-2014 12:10 PM
Update Temp Table From Temp Table Results sross81 SQL Server 3 03-08-2013 08:46 AM
Number losing decimal when moved from temp table to home table CBR1000f Queries 3 01-22-2013 06:00 PM
Test Value in Temp Table Datasheet Does not Exist in Another Table SalisburyLad Modules & VBA 5 06-12-2010 02:46 AM
records existing in Main table not found in Temp Table casey Queries 2 04-12-2007 06:23 AM




All times are GMT -8. The time now is 09:46 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World