I would use the form wizard to create the
customer form then use the subform tool to create the items sold subform. The wizards
will ask you the question which field in the two tables identify the link
between the two tables and link the subform automatically to the main form.
This is easier for me than trying to programmatically
perform the same tasks. As well it also shows me how to do the same later.
Carl
From: AccessDevelopers@yahoogroups.com [mailto:AccessDevelopers@yahoogroups.com] On Behalf Of peaches1979_2001
Sent: Saturday, December 17, 2005
3:55 PM
To: AccessDevelopers@yahoogroups.com
Subject: [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 them
Customer tabe----number (Auto number), id, name,
address, city,
state, zip, email addresss
Sold----Number they bought (auto number), Qty,
discription, price
I 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:AccessDevelopers@yahoogroups.com]
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+databa
se&w4=M
>
icrosoft+access+training&w5=Microsoft+access+training+course&w6=Micro
soft+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+databas
e&w4=Mi
>
crosoft+access+training&w5=Microsoft+access+training+course&w6=Micros
oft+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+databas
e&w4=Mi
>
crosoft+access+training&w5=Microsoft+access+training+course&w6=Micros
oft+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+data
base&w4
>
=Microsoft+access+training&w5=Microsoft+access+training+course&w6=Mic
rosoft+
>
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
YAHOO! GROUPS LINKS
