creating a datatbase for small biz phone orders

[sp13yarn]

I am needing help creating the exact database I want to track customers and orders for a small business' phone orders. My specific questions:

- Can I add information to one record without making the change across the entire database? (as in adding orders to returning customers' record - but not changing anything in the other records?)

- Is there a way to add a "notes" field to store any relevant information for customers?

Thanks!

[Jarvis]

Something to add to your wish list might be some kind of caller ID function that recognizes who is calling and brings up their last record.

Start with a DATA ENTRY LAYOUT that contains a text field NOTES;

Augment this layout with another layout called CUSTOMER PHONE NUMBERS.

Make the second layout a columnar list type layout that contains just the fields NAME & PHONE NUMBER.

You can script the navigation between both layouts with a GO TO LAYOUT"X" button.

If you make this button transparent and lay it over the NAME field on the second layout you can click on a customers name to take you to the DATA ENTRY LAYOUT.

Jarvis