Newbie requests some guidance
1st time post, and I'm sorry if it's in the wrong place - I couldn't find a 'newbie' section.
I am creating a database which needs alot of cross-refrencing...
I want to list all seasonal produce by month, and all information relative...
Carrots in a search would give the following results: -
[Jan][Feb][Mar] in season
[Orange] in colour
[Potato][Cabbage][Parsnip] in other available vegetables
With options to re-select [Orange] or [Potato] to see the details for those categories.
I think this is probably very complex, but I'd like a tip on how the information should be stored, in individual fields, and how they get cross referenced to one-another and so displayed?
I hope this makes sense?!
Thanks in advance!