How to do master detail in excel

  • Thread starter Thread starter DAXU
  • Start date Start date
D

DAXU

Hello,
I have a master/detail style database. For example,
Master table:
id, name, address
1, jerry, 17 avenue

Detail table:
id, masterID, project, status
1, 1, "caranalysis", "going"

Is there a way to display this kind of master and detail relationship
in a excel spreadsheet?

Cheers,

Jerry
 
Depending on how many unique ID's you have and what you want to do with the
data, I would keep all the info for one ID on its own worksheet.
But really Access is the way to go with this.
best wishes
 
Depending on how many unique ID's you have and what you want to do with the
data, I would keep all the info for one ID on its own worksheet.
But really Access is the way to go with this.
best wishes
Click to expand...

I am doing a project to export a master/detail database to excel (The
client wants it). It is easy to export to excel, but I did not find a
nice way to handle the relationship.

Cheers,
 
What do you want the final to look like?
id, name, address 1, "caranalysis", "going
 
Back
Top