Adding a Feild

  • Thread starter Thread starter Kristian Ward
  • Start date Start date
K

Kristian Ward

hello,

I am new to access and i went to the templates where you
can download office files.

i downloaded a database that i want to configure to use
with my new business. I was wondering how i can add a
feild where it tracks the calls i make to each customer???

any ideas?

thanks

Kristian Ward
www.arentalplace.com
 
Sure, it's actually fairly easy.

1. Open a new table in Design View and add either a text field or a memo
field. Use the memo field if notes must be bigger than 255 characters.
2. Add the CustomerID field. This need to be a match in datatype (and
usually name) to the same field in the Customers table.
3. Save it.
3. Build and save a form to act as a subform to hold the notes.
4. Open the Customer form in Design View, turn on the wizard (magic wand
icon) and select the subform control from the tool bar.
5. Make some room on your form and put a subform on your main form
6. Follow the wizard instructions.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top