Posted on 2011-05-06
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.