Good day everyone
I am new at this,so i hope i am doing it right.
I urgently need help.I constructing a Client Database,to handel and tha holds all the info on my clients,from the new ons,to the oldest ones.
What i am strugling with now is,i import 13 different agricultural brands.Each one of these brands have around 5 - 30 different products.
What i want example.
i have a spreadsheet:
A1 Name /A2 surname / A3 Telephone / A4 (a drop down list were you can choose one of the 13 brands) i want to add another colomn (A5) were say you pick "APPLE" from the drop down list in A4 ,in the new colomn A5 it should give you a new list with the different apples to choose from.If i maybe pick pears from the first list A4 it should give me a list in A5 of the different pears you can get from me.
And that is waht i want to do with all my brands and products,so when a client phones in,or walk in i can easily and quickly take note of what he wants.
Thanks
Kobus
I am new at this,so i hope i am doing it right.
I urgently need help.I constructing a Client Database,to handel and tha holds all the info on my clients,from the new ons,to the oldest ones.
What i am strugling with now is,i import 13 different agricultural brands.Each one of these brands have around 5 - 30 different products.
What i want example.
i have a spreadsheet:
A1 Name /A2 surname / A3 Telephone / A4 (a drop down list were you can choose one of the 13 brands) i want to add another colomn (A5) were say you pick "APPLE" from the drop down list in A4 ,in the new colomn A5 it should give you a new list with the different apples to choose from.If i maybe pick pears from the first list A4 it should give me a list in A5 of the different pears you can get from me.
And that is waht i want to do with all my brands and products,so when a client phones in,or walk in i can easily and quickly take note of what he wants.
Thanks
Kobus
ffice
></o
