Problem with forms

[WilliamCarr]

Hi all,

Im currently making a Access database for a company that i work for and need a little help with a small matter that i can resolve myself.

The company want me to make a database that allows them to enter a customers details and then add comments to the customers records, Easy i thought and i progressed with creating the database. Now they want they want to be able to update the comments field more than once and each time they add a new comment they wish it to be date stamped.

So i created a separate table for them to add a comment but i don't know how to relate the comment back to the existing customer, i have pulled through the customers forename but ive hid a block as to relate the fields back to the first table.



If anyone can help then id be really grateful.. thanks.

[SoftwareMatters]

You should add a field to the comments table that links to the main table on the main tables primary key. Then you can create a subform that will link to the main form using this field.