Linking Records in a Report

[Ray A Gsi]

I am new to Access, so not sure if this is possible:

Can I format a report so that in a particular column the information from selected records is visibly highlighted as being linked to the adjacent record ?

eg. Is there any way, in a long list of people, that I can mark, link or highlight the fact that Jane JONES's 1st marriage was to John SMITH & her second was to John BROWN ?

NAME 1 Name 2 MARRIAGE 1 Marriage 1 Detail MARRIAGE 2 Marriage 2 Detail
John.....SMITH marriage......12.12.1812
Jane.....JONES marriage......12.12.1812.........marriage......12.12.1824
JOHN.....BROWN.........................................marriage......12.12.1824

If that is possible, can it be done between records which are NOT adjacent ? ie when Jane JONES marries for the third time ?

Help please.
Thanks,
Ray.

 

[josephwalter]

Which field tells you to whom she was married? For example, if multiple men had a Marriage2Detail value of 12.12.1824, how would you know which men were and were not married to Jane Jones (who's Marriage1Detail is also 12.12.1824)? BTW, is 12.12.1824 a date?

 

[Ray A Gsi]

12.12.1812 & 12.12.1824 are dates, but obviously too early to be recognisable as such by Microsoft. I would store them elsewhere as separate days, months & years so I could do age calculations etc.

Because I am new I am trying to find out if what I want to do is possible before I start to build the database, but the plan is to have (amongst other things) a Table of Event Types, a Table of Events, a Table of Relationships and a Table of People, which are linked.

To help you I reckon the Fields that would identify who was married to whom would be "Spouse" within the Table of People and "Husband" or "Wife" in the Table of Events.

Because of the amount of data I wish to show for each person in this (single) Report (Dates & Places of Birth, Marriage, Divorce, Death etc; Cause of Death, Education, War Service, Employment etc etc.) I do not want to include more in the Report than is absolutely necessary to identify each married couple. This is why I am looking for some alternate way of showing the link in theTable rather than extra Fields.

I hope that helps. I realise it may not be possible, but I need to know before I start, so that is why I turn to the experts.

Many thanks,
Ray.

 

[Kila]

Family Tree?

You seem to be possibly working on a family tree? If so, there is a really good database program out there called Family Tree Maker by Genealogy.com. I think last time I bought version 9.0 for about $60. I think they are at version 10.0 or 11.0 by now. However, it is a GREAT program. We have a tree with three unrelated branches (at least we don't know HOW they are related) of over 1000 individuals dating back to 1685(?). The program is easy to use & you can plug-&-chug all the various info you referred to plus pictures etc. without totally reinventing the wheel. Plus it has other features. This year we used the program to generate our family tree to hang at the reunion... all three parts of course. The longest was 29 feet long. We also have a thick book that is a text version.

If you are not creating a family tree, you can also use the program to track different groups of people. The printouts will show the various marriages.

Not Access, I know, but if something else is out there, why go thru so much effort?

 

[Pat Hartman]

12.12.1812 & 12.12.1824 are dates, but obviously too early to be recognisable as such by Microsoft.

- Not so. Here is what help has to say on the capacity of a date/time field:

Date/Time Date and time values for the years 100 through 9999.