data binding doesn't appear

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
Click to expand...

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]
 
Back
Top