JohnHamer1977
Baseband Member
- Messages
- 44
HI,
I need some help with MS ACCESS
I am trying to make a Customer/client database
I want to use the "Contact" template, but remove the American bits and replace with UK stuff and business phone and fax removed.
I also want to add some more fields like:
- Who reffered them to us
- Who they have reffered to us
- Our services they have in credit (like sunbed mins)
I make all the changes to the coumns and add new fields...
then it saves as Table1.
(see pic below) But I can not open the small contact "details" screen (comes up when you click on a contacts ID) with the newly created Table1.
Do I have to save Table1 in a certain way?
Thats where I am stuck... probably somthing obvious.
THIS SHOULD BE EASY!!! or am I just dumb.
I need some help with MS ACCESS
I am trying to make a Customer/client database
I want to use the "Contact" template, but remove the American bits and replace with UK stuff and business phone and fax removed.
I also want to add some more fields like:
- Who reffered them to us
- Who they have reffered to us
- Our services they have in credit (like sunbed mins)
I make all the changes to the coumns and add new fields...
then it saves as Table1.
(see pic below) But I can not open the small contact "details" screen (comes up when you click on a contacts ID) with the newly created Table1.
Do I have to save Table1 in a certain way?
Thats where I am stuck... probably somthing obvious.
THIS SHOULD BE EASY!!! or am I just dumb.