Fields

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

Guest

Using Office 2003 -
I have a table with two fields "Date of Contact" and "Comments". The
Comment field is set up as a memo field so that the text can be limitless.
My co-workers will write in these fields any time they speak with a client.
I would like to retain all the information and dates of contact in a history
table. Can I change the parameters in these two fields to allow continuous
updates without overwriting the existing data? The way I have it now - each
time we enter a new date for the same client the old date is removed. And
the comments are just all running together.
Thanks in advance for your assitance.
 
Time to set up a separate table to hold the Date of Contact and the Comments
data. That table should also have a primary key field, and a foreign key
field (the foreign key holds the value of the current table's primary key
field so that you can link this table's records back to the current table's
records).

Then, each contact is entered into a separate record in this new table. Do
this by a form and subform setup, where the main form is the data from the
current table, and the subform is the data from the new table. Link the main
form and the subform via the primary / foreign key fields (in form design
view, with Properties window open to the Data tab, click on the subform
control and set the LinkMasterFields property to the name of the primary key
field in the current table; and set the LinkChildFields property to the name
of the foreign key in the new table).
 
You helped me several weeks ago with this problem and I just do not
understand the foreign key. My knowledge of Access is very basic. My file
is .mdb and I tried to locate info about the foreign key but I find nothing
helpful. Please tell me how to set up the foreign key.
My primary key table will hold an "aggregate chain" number that is the key
and the only other fields are contact name, contact date, and coments.
What info should be in the Foreign table?
I would like a separate entry for each date of contact and comments.
Thanks for your help...and sorry I am not understanding.
 
Generically, this is what you would have for your tables:

Main table:
AggregateChainID primary key
ContactName
ContactDate
Comments

Foreign table:
PrimaryKeyField primary key
AggregateChainID foreign key (this field will hold the
same value as the AggregateChainID
field in the parent record in the Main
table; you manually or programmatically
enter this value into this "foreign"
table
AnotherField
AnotherField2


Thus, each record in the Foreign table is related to one record in the Main
table. The link is provided by the values in the AggregateChainID fields in
both tables.
--

Ken Snell
<MS ACCESS MVP>
 
Back
Top