Text Field

  • Thread starter Thread starter KC
  • Start date Start date
K

KC

I have created a database using linked tables. There are no notes fields in
those tables and I need one. I created a text field and entered a comment but
that comment appears against every record but I want it to stay within the
record it was recorded against. Anyone help ?
 
Hi KC

Where did you create the text field?

Since the table is linked, you need to create the text field in your data
source, where ever the tables actually reside.

If you created the text field (box) on a form, it will not be bound to a
particular record and thus it will show up for all of the records, similar
to a label.
 
The problem I have is I created extra columns in the source tables but users
will not be able to write back to those tables
 
You might want to create a new table in your database called tblNotes or
tblComments or something. Link this table to your linked tables in your
database and then the extra notes can stay just in the database, not the
original data source.

CJ
 
Back
Top