creating new fields from form

[mike02]

Hey,


I have my table set up as this:

ID(PK)
CompanyID(FK)
CallDate
Comments (Memo)

What i am trying to do is everytime I make contact with a company i have to make notes. and i want to keep them in my DB. How can i set up my form to
have a button(Forexample) saying New Note, and then a new field, with corresponding date.

I have thought of a table for each Company, but then I would have hundreds of tables. Any Ideas?

Thanks,

[LillMcGill]

I would usually approach this with a main form (Customers), and a subform (Notes), but an alternative is to have a button on the Customers form that opens the Notes form to the correct CustomerID. Many people will tell you to use VBA, but macros in version 2010 are awesome and much easier to master.

Create a button on the Customers form. Go to the OnClick property, click the Build button (has 3 dots on it), and choose Macro builder. Choose the action OpenForm. In the arguments for the action, you will specify the name of the form. You will also have to specify the correct customer record (the "correct record" is the one that is currently displayed on the Customers form).
It will look something like this, depending on the name of your Customers form: [CustomerID]=[Forms]![frmCustomers]![CustomerID]