RE: [AccessDevelopers] Need Help with my Access File

Thu, 22 Dec 2005 13:34:04 -0800

Title: Message
Tom,
Do you agree with my previous response about using three tables?
 
 

Glenn P. Jones

IHS 

-----Original Message-----
From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Tom Oakes
Sent: Thursday, 22 December, 2005 16:14
To: AccessDevelopers@yahoogroups.com
Subject: RE: [AccessDevelopers] Need Help with my Access File

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: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of peaches1979_2001
Sent: Wednesday, December 21, 2005 10:00 PM
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



Reply via email to