[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Access  2007

Posted on 2011-05-06
Medium Priority
Last Modified: 2012-05-11
My OS is windows 7, and I have 2 tables.  One is called tblCampaign.  There are 2 fields, one is an ID which is an autonumber and the other is a text field, called Campaign Name.
The other table is called tblKeywords.  Also there are 2 fields, one is an ID which is an autonumber and the other is a text field, called keywords.
I would like to set a one to many relationship as follows :
Campaign Name 1 to many (Keywords)
Thus a campaign name like "Free Energy" can contain keywords like : Free; Less Cost, etc.
I created 2 tables as above, but when I tried to set the relationship on the field names, campaign Name to Keywords, a 1 to many I got an error that it must be the same type etc.
How do I do this. thank u.
Question by:jegajothy
LVL 12

Accepted Solution

danishani earned 1000 total points
ID: 35706879
You can do this as following;
ID (AutoNumber)
CampID (Number)

CampID (Number)
Keywords (text)

Then you can create a one-to-many relationship with CampID from tblCampaign to tblKeyWords.

LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 1000 total points
ID: 35706898
The Datatypes/properties of the fields you are trying to link must be the same.

Meaning that if you join two number fields, the fact that they are numbers is not enough, the FieldSize property must be the same for the two fields (Long, Integer, Double, Single, Byte, ...etc)

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question