Pulling data from second table
Posted: Mon Jul 30, 2018 6:26 pm
Hello everyone, I've been researching and learning about Base, spreadsheets, databases... and right now I'm just confused with so much information.
This is for a dance competition where dancers have to receive a package of photos with all their corresponding routines. Each dancer may compete with one or more routines. And each routine may include one or more dancers.
This is what I'd like to do:
TABLE I: ROUTINES INFO
ROUTINE NO | ROUTINE NAME | ROUTINE LINK
ROUTINE 01 | ROUTINE NAME 01 | ROUTINE LINK 01
ROUTINE 02 | ROUTINE NAME 02 | ROUTINE LINK 02
ROUTINE 03 | ROUTINE NAME 03 | ROUTINE LINK 03
.
.
.
TABLE II: DANCERS INFO
DANCER NAME | SCHOOL | ROUTINE NO | ROUTINE NAME | ROUTINE LINK
DANCER NAME 01 | SCHOOL N | ROUTINE 01 | (pull from TABLE I) | (pull from TABLE I)
DANCER NAME 01 | SCHOOL N | ROUTINE 07 | (pull from TABLE I) | (pull from TABLE I)
DANCER NAME 01 | SCHOOL N | ROUTINE 35 | (pull from TABLE I) | (pull from TABLE I)
DANCER NAME 01 | SCHOOL N | ROUTINE 01 | (pull from TABLE I) | (pull from TABLE I)
DANCER NAME 02 | SCHOOL H | ROUTINE 22 | (pull from TABLE I) | (pull from TABLE I)
DANCER NAME 02 | SCHOOL H | ROUTINE 64 | (pull from TABLE I) | (pull from TABLE I)
DANCER NAME 03 | SCHOOL N | ROUTINE 07 | (pull from TABLE I) | (pull from TABLE I)
DANCER NAME 03 | SCHOOL N | ROUTINE 09 | (pull from TABLE I) | (pull from TABLE I)
DANCER NAME 04 | SCHOOL D | ROUTINE 08 | (pull from TABLE I) | (pull from TABLE I)
.
.
.
Thanks in advance for your help
This is for a dance competition where dancers have to receive a package of photos with all their corresponding routines. Each dancer may compete with one or more routines. And each routine may include one or more dancers.
This is what I'd like to do:
TABLE I: ROUTINES INFO
ROUTINE NO | ROUTINE NAME | ROUTINE LINK
ROUTINE 01 | ROUTINE NAME 01 | ROUTINE LINK 01
ROUTINE 02 | ROUTINE NAME 02 | ROUTINE LINK 02
ROUTINE 03 | ROUTINE NAME 03 | ROUTINE LINK 03
.
.
.
TABLE II: DANCERS INFO
DANCER NAME | SCHOOL | ROUTINE NO | ROUTINE NAME | ROUTINE LINK
DANCER NAME 01 | SCHOOL N | ROUTINE 01 | (pull from TABLE I) | (pull from TABLE I)
DANCER NAME 01 | SCHOOL N | ROUTINE 07 | (pull from TABLE I) | (pull from TABLE I)
DANCER NAME 01 | SCHOOL N | ROUTINE 35 | (pull from TABLE I) | (pull from TABLE I)
DANCER NAME 01 | SCHOOL N | ROUTINE 01 | (pull from TABLE I) | (pull from TABLE I)
DANCER NAME 02 | SCHOOL H | ROUTINE 22 | (pull from TABLE I) | (pull from TABLE I)
DANCER NAME 02 | SCHOOL H | ROUTINE 64 | (pull from TABLE I) | (pull from TABLE I)
DANCER NAME 03 | SCHOOL N | ROUTINE 07 | (pull from TABLE I) | (pull from TABLE I)
DANCER NAME 03 | SCHOOL N | ROUTINE 09 | (pull from TABLE I) | (pull from TABLE I)
DANCER NAME 04 | SCHOOL D | ROUTINE 08 | (pull from TABLE I) | (pull from TABLE I)
.
.
.
Thanks in advance for your help