Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Subdatasheets

Status
Not open for further replies.
J0ANNE

J0ANNE

Technical User
Joined
Mar 9, 2004
Messages
6
Location
GB
I have create a customer database, my tables consist of customers, contact numbers and 08 numbers.
I want to create a relationship from the customer table to the contact number table and again from the customer table to the 08 number table.
Is this possible?
If so how do I go about doing it?
Thanks
 
Sort by date Sort by votes
Joanne
Go into Tools > Relationships.
Add your three tables. Then drop/drag the fields that you want to create a relationship to.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Xavierparkash
  • Locked
  • Question Question
MS Access Slow Search in Linked Database
Replies
0
Views
638
Xavierparkash
Xavierparkash
JanaLNelson
  • Locked
  • Question Question
Filter as you type combo box in Access
2 3
Replies
54
Views
4K
JanaLNelson
JanaLNelson
TheresAlwaysAWay
  • Locked
  • Question Question
"There isn't enough memory to perform this operation..." error after upgrading from Access
Replies
2
Views
588
Axworthy
Axworthy
leifoet
  • Locked
  • Question Question
How to store decimal numbers in an Access database?
2
Replies
27
Views
3K
Andrzejek
Andrzejek
priac
  • Locked
  • Question Question
Create a Duplicate of an Existing Record in Microsoft Access but leave some fields blank.
Replies
7
Views
2K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top