Create a new field in the Parent table, and define it as an Autoenter Lookup from the child table.
Write a short script to go to that Parent table field...then "Relookup" field contents. (This is a script only because that's where the "relookup" function is)
Then uncheck the "autoenter Lookup" function so it is no longer a lookup.
This will move your data from the child field to the parent field without all the typing.
Probably an easier way, but this one is just a few minutes of work.
One last question: (I should have included this bit of information)
I saw an answer on another forum (actually answered by you):
If there is no related record in the child table, a related record must be created in order to enter the value. And from your "parent table" layout, this record is created via the relationship.
This is my issue. The child table is much less populated than the parent. Will what you've described above still work?
That does not seem to make sense. If there is no child record then there is no data to pull into the parent.
As Bruce points out, if there is no data in the source (child), there is nothing to put into the target (parent).
All the same, the lookup function can still work if the lookup properties are set correctly.
Simply choose (in the lookup settings),
- If no exact match, then: select "do not copy"
- Check the box at the bottom "Don't copy contents if empty"
The child fields that HAVE data will pull over to the parent
The child records the DO NOT HAVE data ...the parent field will remain empty.
If for some reason you want a default value to go into the parent field if there is no child record, simply select "If no exact match, then::: use _________ " and fill in the blank with what you want the parent field to have.
Note that ALL parent records with no child will get this same value.
Note that you do not need to define the field as a look up and then change it. You can just use the replace command to populate the field.
LOL....told you there was probably an easier way
Now, since this IS a child table – what value is supposed to go into the new field if there are multiple children …?