NeoNemesis
Registered User.
- Local time
- Today, 11:22
- Joined
- Nov 18, 2002
- Messages
- 19
I am creating a database in Access to store all of my customers that I do business with and also storing all the details of the visits that I make to them.
I am planning to add bits extra to it after the main bulk has been done.
Currently I have two tables as follows,
Customer Details:
Visit Details:
They are related by the two Customer ID fields.
The problem that i am having is that I want the name of the CustomerName to appear automatically in the VisitDetails Table when I enter the CustomerID but for some reason I just cant make it happen!
Any pointers please? I'm only a novice when it comes to Access so help from you guys may be an ongoing thing if that is ok
.
Thanks in advance.
NeoNemesis
Joe
I am planning to add bits extra to it after the main bulk has been done.
Currently I have two tables as follows,
Customer Details:
- CustomerID - Autonumber (Primary Key)
- CustomerName
- All the address fields
- Phone
- Fax
Visit Details:
- VisitID - Autonumber (primary key)
- CustomerID
- CustomerName
- VisitDate
- VisitAttendees
- VIsitAgenda
- ActionItem1
- ActionItem2
- ActionItem3
- ActionItem4
They are related by the two Customer ID fields.
The problem that i am having is that I want the name of the CustomerName to appear automatically in the VisitDetails Table when I enter the CustomerID but for some reason I just cant make it happen!
Any pointers please? I'm only a novice when it comes to Access so help from you guys may be an ongoing thing if that is ok

Thanks in advance.
NeoNemesis
Joe