Hi,
I have question about do right query and then report.
In past I did tables for menus like this :
id ; colours ; red ; light red
id ; colours ; red ; dark red
id ; colours ; green
id ; colours ; blue
id ; food ; fruit ; apple
id ; food ; fruit ; ....
id ; food ; vegetables ; carrots
etc.
... so I always need to have some number of fields in the table (in this example three).
Now Iam using menu with only two fields and there are no limitations of number of subcategories.
example :
code text
1. colours
2. food
1.1. red
1.2. green
1.1.1. dark red
1.1.2. light red
It works really well. But I dont know how to do outputs to reports, for ex.like this :
colours
red
light red
text about light red colour ...
dark red
text about dark red colour ...
green
etc.
In the first example it was easy but with using number codes in table I dont know how to do it.
Can you help me anyone?
Thanks a lot.
Jiri
I have question about do right query and then report.
In past I did tables for menus like this :
id ; colours ; red ; light red
id ; colours ; red ; dark red
id ; colours ; green
id ; colours ; blue
id ; food ; fruit ; apple
id ; food ; fruit ; ....
id ; food ; vegetables ; carrots
etc.
... so I always need to have some number of fields in the table (in this example three).
Now Iam using menu with only two fields and there are no limitations of number of subcategories.
example :
code text
1. colours
2. food
1.1. red
1.2. green
1.1.1. dark red
1.1.2. light red
It works really well. But I dont know how to do outputs to reports, for ex.like this :
colours
red
light red
text about light red colour ...
dark red
text about dark red colour ...
green
etc.
In the first example it was easy but with using number codes in table I dont know how to do it.
Can you help me anyone?
Thanks a lot.
Jiri
