Ask Your Question

kimborg's profile - activity

2017-12-18 12:06:07 +0200 received badge  Notable Question (source)
2016-08-14 22:32:51 +0200 received badge  Popular Question (source)
2016-05-03 14:26:18 +0200 received badge  Enthusiast
2016-05-02 21:03:11 +0200 commented answer Connecting three tables: client, year, course(s)

Thanks, this seems very helpful. And I'll look into the post you mentioned.

2016-05-02 19:36:32 +0200 received badge  Editor (source)
2016-05-02 19:14:44 +0200 asked a question Connecting three tables: client, year, course(s)

I run a yoga-studio, and would like to use Base as a kind of CRM, registering my clients purchase history (using data from my webshop). On a clients record form, I would like to pick a year, say 2013, and then have a dropdown-list over courses that were available that year. And then choose from that list to register the clients course(s) in 2013. The same would apply for any other year, of course, until I have a complete history in Base. I have figured out how to establish relationship between two tables, for instance «clients» and «courses». And, of course, the same would appy for tables «years» and «courses». But I haven't figured out how to connect three tables, so that I can enter purchase history like mentioned above (client→year→course(s) for that year). I'm sure there's a simple solution to this, and would be grateful for any assistance. If my description is unclear, let me know, and I'll try to clarify.