Hi,

On page 44, step 13, I click the ellipsis button on Tables and Columns Specification property. (My selected Relationship is FK_Person_Person) The Tables and Columns dialogue opens. I choose POUser as the Primary Key table. The FK table already set to Person. In the POUser Column (left side of the dialogue window), I choose 'ID' and in the Person column (right side) I choose 'POUserID'.

I click OK to set the foreign key, as instructed. It is indicated in the book that this will continue back to the Foreign Key Relationships dialogue box, which I can then close to return to the table view in VB Express. However, when I click OK to set that foreign key, I get an error instead:

"The columns in table 'POUser' do not match an existing primary key or UNIQUE constraint."

I've checked over the instructions, and I am fairly certain I have not missed a step. Yet this error pops up and I cannot continue with the examples.

Any ideas?

http://renkai.com

Hi Renkai,

It sounds like the ID field has not been set to be the primary key. Alternatively, it could be that you have not set its unique and autonumber properties.

Could you please check both tables to see if they have primary keys set? Also, just double check that the POUserID field in the Person table is defined as an integer.

Thanks
Andrew

Hi Andrew, thanks very much - that was it. I knew I was missing something but didn't know what it was!

I'm enjoying your book so far, thanks again for the response.

http://renkai.com

No problem Renkai. I am glad you're enjoying the book - I'm always happy to hear from people who've got something out of it.

Cheerio
Andrew