copy info in field

[Bladerunner]

Not exactly sure how to say this but:

Have a form/subform combo.
Main form represents--Birthrecord table Sub form= offspringrecord
A Dam field in the Birthrecord is connected to the Main Tables- Animal ID.
The two tables on the form are connected via the same field type (Dam).
Two tables are updated and work well except the (Dam) field. How can I get the Dam ID from the Birthrecord to the subforms offspring record.

I have tried just about everything I can think of or read about. Nothing helps. When it saves the info from the form, it saves all but the (Dam) ID number in the offspringrecord table.

Thanks


Bladerunner

 

[mikejaytlabustro]

Can you elaborate further

1. How many tables do you have?
2. What are the fields in each Table?

 

[Bladerunner]

Have solved that problem. Simply append (make a new record) in another table. Works fines. However, I am still having a problem with what should be a simple update procedure.

How can I update the this field in [tblSetup].[ID],[tblSetup].[CurrentWgt] from [tblHealthcare].[ID],[tblHealthcare].[HealthWgt]

 

[Bladerunner]

Where is my manners: Sorry not to answer your questions.

How many tables do you have?
In the frmBirthRecord, subformProgeny, two tables.
What are the fields in each Table
about 8-10 field in each table.

To fix the above problem I simply added a text field to Progeny where the user could simply input the Dam ID again. Repettive Yes. Not really the best way I wanted to do it but right now until I can do better, it will do. I then append the Progeny Subforms info to tblSetup. Here the info is treated as a new animal. (i.e. birthID =animal ID)

Now I have an additional problem: Have one field that is in the frmBirthrecord that needs to transferred/copied to the like field in tblSetup. The record in the tblsetup would be the Dams ID record. Gravidia (number of offspring)

So the question is: How can I update the this field in [tblSetup].[ID],[tblSetup].[Gravidia] from [tblbirthrecord].[ID],[tblBirthrecord].[Gravidia]


Got any suggestion.

Again, I am sorry for not answering your question, It was very rude of me.

Bladerunner