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: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of peaches1979_2001
Sent: Wednesday, December 21, 2005 10:00 PM
To: [email protected]
Subject: [AccessDevelopers] Need Help with my Access File
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
- 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.
