RE: [AccessDevelopers] Re: Need Help Creating MS Access Database

[Tom Oakes]

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.  

 

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: Saturday, December 17, 2005 12:55 
PMTo: AccessDevelopers@yahoogroups.comSubject: 
[AccessDevelopers] Re: Need Help Creating MS Access 
Database
I think you need to create a query form. Here is a list of 
two tables that I have in themCustomer tabe----number (Auto number), id, 
name, address, city, state, zip, email addresssSold----Number they 
bought (auto number), Qty, discription, priceI want the subform to match 
the customer information on each record and be different on each of the 
cutomer that i ave sold to. --- In 
AccessDevelopers@yahoogroups.com, "Tom Oakes" <[EMAIL PROTECTED]> 
wrote:>> I don't think you need to join tables in a query for 
this one.>  > 1) create your main form; with the customer 
table as the source> 2) add a subform to your main form; with the "sold" 
table as the source>  > The "sold" table needs to have a 
customer id in it, or something to link it> to the customer 
record.  You'll specify the relationship between the form> and 
subform when you add the subform.>  > 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_2001> Sent: Friday, December 16, 2005 10:52 PM> 
To: AccessDevelopers@yahoogroups.com> Subject: [AccessDevelopers] Need 
Help Creating MS Access Database> > > I am trying to create 
a database for my customers where I just type in > the information in 
the form. My main problem is trying to create a > subform where I just 
want the following:> > Number have bought> Qty> 
Discription> Price> > I hvae one table for my cutomers and 
another table for sold. I know I > need to have two tables in the 
Quries..but I don't know what other > table should have? Any ideas? I am 
going to be using this with Ebay > when I sell stuff.> 
> IF anyone can help me out, I apprecitate it. > > > 
> > > > Please zip all files prior to uploading to 
Files section. > > > > > SPONSORED LINKS 
> Microsoft> <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+developer&w1=Microsoft> 
+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w4=M> 
icrosoft+access+training&w5=Microsoft+access+training+course&w6=Microsoft+ac> 
cess+programming&c=6&s=193&.sig=d-CjBIrYOH9NCKHYFeGZJA> access 
developer> Microsoft> <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+help&w1=Microsoft+acce> 
ss+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w4=Micros> 
oft+access+training&w5=Microsoft+access+training+course&w6=Microsoft+access+> 
programming&c=6&s=193&.sig=crx-d4AAhdklv_VozGVAUw> access help 
      Microsoft> <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database&w1=Microsoft+> 
access+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w4=Mi> 
crosoft+access+training&w5=Microsoft+access+training+course&w6=Microsoft+acc> 
ess+programming&c=6&s=193&.sig=qg2hDuQNweByMCX0NU7cEA> access 
database       > Microsoft> <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+training&w1=Microsoft+> 
access+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w4=Mi> 
crosoft+access+training&w5=Microsoft+access+training+course&w6=Microsoft+acc> 
ess+programming&c=6&s=193&.sig=bLZHqTqWUQny609X1OkmNA> access 
training> Microsoft> <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+training+course&w1=Mic> 
rosoft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+databas> 
e&w4=Microsoft+access+training&w5=Microsoft+access+training+course&w6=Micros> 
oft+access+programming&c=6&s=193&.sig=d8GQXfQW3RZ64rOfzIMo8A> 
access> training course       
Microsoft> <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+programming&w1=Microso> 
ft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w4> 
=Microsoft+access+training&w5=Microsoft+access+training+course&w6=Microsoft+> 
access+programming&c=6&s=193&.sig=iXDlL79-kkgjv6fLyFu3Sg> access 
programming> > >   _____  > 
> YAHOO! GROUPS LINKS > > > 
      > *      Visit 
your group "AccessDevelopers> <http://groups.yahoo.com/group/AccessDevelopers> 
" on the web.>   > > 
*      To unsubscribe from this group, send an email 
to:>  [EMAIL PROTECTED]> 
<mailto:[EMAIL PROTECTED]subject=Unsubscribe> 
>   > > *      Your use 
of Yahoo! Groups is subject to the Yahoo! Terms of Service> <http://docs.yahoo.com/info/terms/> 
. > > >   _____>






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.