How to do master detail in excel

[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

 

[Bernard Liengme]

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

 

[DAXU]

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

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,

 

[Don Guillett]

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