data binding doesn't appear

[Guest]

I created a table with two fields - id and location. This was to avoid
holding the text of articles within the table. In the topic table I created
a field called location. In access I associated them in relationships.

Yet in the visual basic vs 2005 I'm using, location does not appear in the
topic table in my dataset.

Any clues?

dennist

 

[John W. Vinson]

I created a table with two fields - id and location. This was to avoid
holding the text of articles within the table. In the topic table I created
a field called location. In access I associated them in relationships.

Yet in the visual basic vs 2005 I'm using, location does not appear in the
topic table in my dataset.

Ummm...

It doesn't appear because it's not in that table. What's in the table is the
ID; having a relationship will not change that fact.

If you want to see the Location in connection with the text, don't look at the
Table - look at a Query (or Recordset based on a query) joining the articles
table to the location table, joining by ID.

John W. Vinson [MVP]