I'm not sure if Access is the right tool for this, it's not a tool I'm particularly familiar with - if any can tell me either how to do this in access, or whether some other program might be better, it would be appreciated!
We have compounds, we then take those compounds and modify them. The modified compound gets a new name. We want to view all the compounds in 1 list along with various other pieces of info (which shelf they are on etc), but importantly we want to keep a record of the relationship between them. Over time, there will be quite extensive relationships between different samples, and we want to be able to click on something & see all the parents and/or all the children.
If I set up 2 columns - column A is compound name, column B is the parent compound. I've set column B up as a lookup to the first column. So far, so good - but then how would I visualise the relationships between the compounds? Am I even setting the table up in the right way?
Thanks!
We have compounds, we then take those compounds and modify them. The modified compound gets a new name. We want to view all the compounds in 1 list along with various other pieces of info (which shelf they are on etc), but importantly we want to keep a record of the relationship between them. Over time, there will be quite extensive relationships between different samples, and we want to be able to click on something & see all the parents and/or all the children.
If I set up 2 columns - column A is compound name, column B is the parent compound. I've set column B up as a lookup to the first column. So far, so good - but then how would I visualise the relationships between the compounds? Am I even setting the table up in the right way?
Thanks!