So I’m building a database for my garden seed sowing.
I have three tables:
Seed Varieties, Seed Purchases and Seed Sowing
So for example I may list Sweet pea Leamington in Seed Varieties, then purchase these seeds from a particular company, then sow seeds from that packet over a couple of years.
I can create a main form, then a sub-form of purchases, but how do I make a sub-form of a sub-form. So when I click on each row of the seed purchases sub-form, an additional sub-form shows when I sowed them.
So Seed Varieties may contain ID Name Type Colour Seed Purchases may contain ID Seed ID Company Purchase Date Expiry Date Seed Sowing may contain ID Sowing Date Germination Date Germination Rating Transplant Date Flowering Date
I can provide my database if that helps.