Hi there
Am creating a database of children's heights. Have a main table with each child's name and age - call it CHILDREN
Each time I see the child I measure their height and weight which are entered into a new table call it GROWTH
What i need is when I measure the height on this occasion I want the date of the last measured height ON THIS CHILD to be automatically entered into the record for this occasion.
I think I need a self join relationship but am not sure how to set it up so that the height is automatically entered.
All help appreciated.
Craig McDonald