Subform headache

[farmerk]

Hi all
I'm trying to make a database to keep track of our cattle. Its made up of a few tables including cattle details, type, husbandry (treatment). My headache seems to be from trying to create a form/subform - the main form has date, treatment type, comments etc. subform has lots of animal details. I'd like to be able to show all active animals (aka alive), and perhaps sort into sub groups eg calves/cows etc depending on treatment. THEN transfer/append all this great info into a new table.

My idea is to be able to select say 30 animals from the cattle detail table, select drench - and have the selected records move to the new table. Mainly to save time, and reduce error.

Any help would be greatly appreciated.
Cheers in advance. Copy attached.

 

[plog]

THEN transfer/append all this great info into a new table

That's not how databases work. Data doesn't get moved, it gets marked. You don't differentiate similar data with tables for each type, you create fields and do it that way.

So, since the Cattle Detail and Treatment tables have the exact same fields, you don't need both. Additionally, you have a 1-1 relationship between Treatment and TreatmentMain. That means there can only be one treatment per cattle. That doesn't seem right. My guess is this needs to be a 1-many relationship.

I'd really need an explanation (without database jargon) of how your operation works. Just explain in English what you do.