The customerID is a hidden field required
to identify the information for the sub form. In order to query the sold table
then display the information for each customer there must be a way to identify
the results. Otherwise you will get all results for all sales for all customers
or absolutely no results at all.
Have you tried the subform wizard to create
the subform? The wizard asks most of the right questions an links the two forms
together for you.
Carl
From: AccessDevelopers@yahoogroups.com [mailto:AccessDevelopers@yahoogroups.com] On Behalf Of peaches1979_2001
Sent: Thursday, December 22, 2005
11:22 PM
To: AccessDevelopers@yahoogroups.com
Subject: [AccessDevelopers] Re:
Need Help with my Access File
What do you mean by third
table? I already have two tables.
I am trying to create a subform just using Item
number, Discription,
Qty, price (from Ebay final price of the item). I
do not want the
cutomer ID in the Subform.
Do I anything in the Queries?
--- In AccessDevelopers@yahoogroups.com,
"Jones, Glenn P MSG (Ret)
FL-ARNG" <[EMAIL PROTECTED]> wrote:
>
> You can see this model in the Northwinds
database which comes with
Access.
> Basically you will want three tables.
One table will be for your
customer
> information where CustomerID is your primary
key (PK).
>
> The second table will be like an inventory
table listing your
products,
> price, item number (PK), and on hand
quantity.
>
> The third table is what is called a join
table. This table will be
your
> Orders table and will join the information
from your Customer table
> (CustomerID) and from your Products table
(ItemNumber). You will
also want
> other fields in your join table such as
quantity, order date, ship
date,
> various costs such as shipping and handling,
total cost. The
reason you
> want a separate order table is because you
may have a customer
that orders
> more than one time. When the order is
placed you can subtract the
quantity
> ordered from the quantity on hand. You
could set an
OrderWhenQuanity value
> for each item in your inventory table and
then when the quantity
on hand is
> equal to or less than that OrderWhenQuanity
value you will know to
order
> more of that product.
>
> I hope this helps.
>
> Glenn P. Jones
>
>
>
>
> -----Original Message-----
> From: AccessDevelopers@yahoogroups.com
> [mailto:AccessDevelopers@yahoogroups.com]
On Behalf Of
peaches1979_2001
> Sent: Thursday, 22 December, 2005 01:00
> To: AccessDevelopers@yahoogroups.com
> Subject: [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, Email
> Sold: Auto Number, Item Number, Discription,
Qty, Price
>
> How 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.
> Yahoo! Groups Links
>
Please zip all files prior to uploading to Files section.
SPONSORED LINKS
YAHOO! GROUPS LINKS
