RE: [AccessDevelopers] Need Help with my Access File

[Tom Oakes]

Title: Message





Hey Glenn, 
 
Yes, absolutely - but I think peaches1979_2001's situation may be a simpler than 
that.  It really depends on whether it's necessary/desirable to maintain an 
product table.
 

Tom Oakes Personal PC Consultants, Inc. [EMAIL PROTECTED] 503.230.0911 (O) 402.968.6946 (C) 734.264.0911 (F) 

 
 



From: 
AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Jones, Glenn P MSG (Ret) FL-ARNGSent: Thursday, 
December 22, 2005 1:34 PMTo: 
AccessDevelopers@yahoogroups.comSubject: RE: [AccessDevelopers] Need 
Help with my Access File

Tom,
Do you 
agree with my previous response about using three tables?
 
 

Glenn P. Jones
IHS 

  
  -----Original Message-----From: 
  AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] 
  On Behalf Of Tom OakesSent: Thursday, 22 December, 2005 
  16:14To: AccessDevelopers@yahoogroups.comSubject: RE: 
  [AccessDevelopers] Need Help with my Access File
  My response from last Saturday: 
  
   
  
  You need to add a field in your "Sold" table 
  that represents the customer number.  FYI, naming a field "Number" 
  is not a good idea, generally speaking.
   
  I'd suggest naming the 
  AutoNumber field in the customers table "CustomerID", and adding a field of 
  type Long, also named CustomerID to the "Sold" table.  Without the 
  CustomerID field in the Sold table, you wouldn't know to which customer a 
  given record relates. 
   
  Have you tried these things?
   
  
  Tom Oakes 
  Personal PC Consultants, Inc. 
  [EMAIL PROTECTED] 503.230.0911 (O) 402.968.6946 (C) 
  734.264.0911 
  (F) 
  
  
  
  From: AccessDevelopers@yahoogroups.com 
  [mailto:[EMAIL PROTECTED] On Behalf Of 
  peaches1979_2001Sent: Wednesday, December 21, 2005 10:00 
  PMTo: AccessDevelopers@yahoogroups.comSubject: 
  [AccessDevelopers] Need Help with my Access File
  Can any one help me with my access file? I could not able to 
  upload to the group in the files folder. I have these two 
  tables:Customer: ID, Name, Address, City, State, Zip, EmailSold: 
  Auto Number, Item Number, Discription, Qty, PriceHow do I link them to 
  the Customer ID just using that? I want each record different for the 
  customer so that I could have a copy of it.I setup my query using the 
  auto number, but it tells me it is invaild _expression_. IF anyone could 
  help me with it, I appreciate it.






Please zip all files prior to uploading to Files section.





    


  
  
    SPONSORED LINKS
  
          
                  
            
        Microsoft access developer
      
                      
        Microsoft access help
      
                      
        Microsoft access database
      
              
                        
            
        Microsoft access training
      
                      
        Microsoft access training course
      
                      
        Microsoft access programming
      
              
                    
           
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "AccessDevelopers" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.