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
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.
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.
