Starting a new dbase

[cloudsurfer]

Hi all, I'm starting a new DB for a new hobby project.
I have a table with people and I have a table with tasks.
Every person can have multiple tasks.

How can I best set it up:
Person table
John
Amy
Pete

Task table
fix car
pay bills
read book

How can I make a link between the 2 tables and select tasks for each person.
Example
John has a task pay bills and fix car and read book
Amy has a task fix car
Pete has a task read book

It's been a while that I setup a DB and I remember that the setup is important.
In the end I want an overview per peson what tasks they need to do.
Thx

 

[plog]

You need a third table, the term the database world uses is "junction table". The technical term is an associative entity:

Associative entity - Wikipedia

en.wikipedia.org

Give that link a read

 

[Dreamweaver]

Hopefully this will give you a few Idears

Database Dreams

databasedreams.createaforum.com

 

[cloudsurfer]

Thx for the answers.
MickJav: for some reason I can't download anything from databasedreams...
Plog: I've used junction with my 2 tables to create a 3rd table.

I've been trying all day now to create a form which does:
dropdown box with names (showing 1 name)
And next to it a list of the 2nd table with all options, possibly with a checkbox next to it. If the checkbox get's ticked, the item and name will be joined in table 3. Mutliple selections for the items.
Any tips?

 

[mike60smart]

Hi
As mentioned you need a 3rd Table. See the attached example.

 

[cloudsurfer]

Mike60smart: exactly what I need to understand the joined 3rd table better and change it to what I need.
Thx

 

[mike60smart]

Glad to help

 

[DittoBird]

You need a third table, the term the database world uses is "junction table". The technical term is an associative entity:

Great link, thank you. For nearly the past two decades I've been using the term "Look up table" and had forgotten the correct term.
--
Tim