Customer History

[Branagan]

Hi,

I currently have a "customer" form (which displays client details from a table - name, address etc) I would like to add history comments for each customer.

Does anyone know how i would go about doing this.

I image i could press a button on the current "customer" form that will open a history form which after typing a comment would be displayed on the main "customer" form, with date, time and comment.
I would obviously be able to add lots of comments to each record.

i would be greatful for any kind of help

Regards
Chris

 

[neileg]

When I need to do this, I create a new table. This will hold the PK from the main table, the date of the entry, the comments and any other data you require.

I would make this a subform on your main form rather than a pop up.

 

[Branagan]

thanks for ur help,

but my current customer form is very big as it is, so i would like a seperate form for each customer's history.

would i need to create a seperate table for all the customer comments, then create a form which displays that, if so how would i link the history form up with the customer

 

[neileg]

Base the form on a query that uses the customer ID on the main form as a criterion.

 

[Mark-BES]

Hi,

I had a similar situation. I adapted the sample database supplied with A97 "Contact Managment" db (I think this also ships with later versions of Access).

On the main form is a "Calls" button. Change this to "comments" and adapt the related form and subform for your requirements.
Hope this helps.