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 strongm 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
Mar 9, 2004
6
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
MS Access Slow Search in Linked Database
Replies
0
Views
151
Xavierparkash
Xavierparkash
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
758
JanaLNelson
JanaLNelson
TheresAlwaysAWay
  • Locked
  • Question
"There isn't enough memory to perform this operation..." error after upgrading from Access
Replies
2
Views
165
Axworthy
Axworthy
leifoet
  • Locked
  • Question
How to store decimal numbers in an Access database?
2
Replies
27
Views
528
Andrzejek
Andrzejek
priac
  • Locked
  • Question
Create a Duplicate of an Existing Record in Microsoft Access but leave some fields blank.
Replies
7
Views
532
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top