Starting a new dbase (1 Viewer)

cloudsurfer

New member
Local time
Today, 23:16
Joined
Mar 23, 2020
Messages
18
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
 

MickJav

Well-known member
Local time
Today, 22:16
Joined
Nov 28, 2005
Messages
2,431
Hopefully this will give you a few Idears

 

cloudsurfer

New member
Local time
Today, 23:16
Joined
Mar 23, 2020
Messages
18
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

Registered User.
Local time
Today, 22:16
Joined
Aug 6, 2017
Messages
687
Hi
As mentioned you need a 3rd Table. See the attached example.
 

Attachments

  • Tasks.zip
    26.9 KB · Views: 16

cloudsurfer

New member
Local time
Today, 23:16
Joined
Mar 23, 2020
Messages
18
Mike60smart: exactly what I need to understand the joined 3rd table better and change it to what I need.
Thx
 

DittoBird

New member
Local time
Today, 18:46
Joined
Nov 16, 2020
Messages
4
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
 

Users who are viewing this thread

Top Bottom