I've got a major problem that I sincerely hope someone can help.
I need to show all livestock on report and if a particular cow has an offspring, then it needs to show below that cow. My query recordsource is based on LivestockID. In addition to the LivestockID, there is a DamID field which lists the ID number of the cow. I cannot seem to pull up the offspring only if it has a parent. I am thinking that maybe a DLookup If the DamID matches the LivestockID - then show. I really don't want to go with a subreport.
Your help is greatly appreciated.
I need to show all livestock on report and if a particular cow has an offspring, then it needs to show below that cow. My query recordsource is based on LivestockID. In addition to the LivestockID, there is a DamID field which lists the ID number of the cow. I cannot seem to pull up the offspring only if it has a parent. I am thinking that maybe a DLookup If the DamID matches the LivestockID - then show. I really don't want to go with a subreport.
Your help is greatly appreciated.
