How can I store/display a series of dates and weights on a form?

[Pedigreeman]

I am recording weight change in eggs over time during the incubation period. Each egg has a unique Egg_ID, and are listed in an underlying table, with details such as parent IDs, date laid, etc.

I would like to incorporate a weight change chart within a form. It would show how the weight has changed during the month of incubation. The egg is weighed periodically, but with no regularity, perhaps 5-10 days of the month of the incubation period (sometimes more sometimes less).

In the Egg_form, I would like to be able to view a chart displaying the weight change over time. I understand that what I need is something between a form and a table (a table to be displayed for each record).

My questions are these:

1) Where would I store the egg weight data (seperate table, or in seperate columns of the existing table?)

2) How can I put both this weight dates table AND the chart on a form? Or so that either can easily be displayed, and the table can easily be edited.

P.S. I am new to access so please try to keep things simple if possible, and thank you very much in advance if you can help me out with this and if anybody has any better ideas of how to go about this, I am all ears.

 

[missinglinq]

Your egg weight data needs to be in a separate table to be used as the record source for your subform. It will have to include the Egg_ID, of course. So

1. Create your egg weight data table as outlined above
2. Create a Datasheet View form for the egg weight data table- the Wizard will do this easily
3. In your original, main form, add a Subform Control
4. When the Wizard comes up select the egg weight data form as the subform's source
5. The Wizard will automatically link the main form/subform via the Egg_ID field.

Now, when you have a given egg record in front of you, you can enter the new weight data and Access will automatically enter the Egg_ID for you.

I've never used charts in Access, so someone else will have to help with that. I do know, though, that there is a Charts Wizard.

Whether you can have room on your form for both depends on how 'busy' your form is. If need be you could have a Tabbed Control with the subform on one page and the chart on another page. In fact, that's probably how I would do it.

BTW, I won't tell you what my grandfather did for a living after he retired from the railroad, but I do what 'candling' means!

Go luck!

Linq ;0)>

 

[DCrake]

Candling? isn't that where you put a candle light behind the egg to see if an egg is sterile or not?

 

[Pedigreeman]

Candling? isn't that where you put a candle light behind the egg to see if an egg is sterile or not?

Forget Access - now you guys are talking my language! It is indeed, after 5 days or so you can normally see some development/movement (or lack of) in the egg by holding a candle behind it. Nowadays we use modified lamps.

Thanks for your suggestions Linq, I am going to have a play around and get back to you...I am intrigued about your grandfathers job...

 

[DCrake]

We used to play a little parlour trick whereby we would boil one of 6 eggs and ask a person to identify the boiled one without picking up any of the eggs. Won many a bet on that one. And no none of the eggs were marked or chipped.

 

[Pedigreeman]

1. Create your egg weight data table as outlined above
2. Create a Datasheet View form for the egg weight data table- the Wizard will do this easily
3. In your original, main form, add a Subform Control
4. When the Wizard comes up select the egg weight data form as the subform's source
5. The Wizard will automatically link the main form/subform via the Egg_ID field.

Great tips, worked perfectly. Datasheet view was the key. Many thanks!

 

[missinglinq]

Glad we could help!

Linq ;0)>