Ask Your Question
0

Connecting three tables: client, year, course(s)

asked 2016-05-02 19:14:44 +0200

kimborg gravatar image

updated 2016-05-02 19:36:32 +0200

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-05-02 20:12:13 +0200

Ratslinger gravatar image

See if this may work for you. I see three tables. First table is 'Courses' containing ID (maybe a unique # which can be used as key), Year and/dates and other pertinent information. Second table is 'Clients' with ID, and other data (name, address etc). Final table is 'Purchases'. This table has an auto-incrementing ID for a key, Client_ID (ties back as one-to-many from to 'Client' table) and Courses_ID (again ties back to 'Courses' table).

With tables in place, the other comment in your question regards forms. Using filtering (see this post) you should be able to create/update/list records in most any combination. In that post are many samples which should help.

edit flag offensive delete link more

Comments

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

kimborg gravatar imagekimborg ( 2016-05-02 21:03:11 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-05-02 19:14:44 +0200

Seen: 45 times

Last updated: May 02 '16