Cindy,
Sometime during testing, I wiped out the first two records of a new table I had been testing with. The last two records in the table replaced the first two records in the same table. So I had records #1 and #2 which matched records #109 and #110. It's not a lengthy table, only 110 records long.
And I do have an old table with most of the same fields in them intact. So instead of manually entering the 40 or so fields to repair the two records that I wiped out, I thought I might be able to move the fields from the old table to the new table, but only the first two records since those were the only ones that got messed up. And I would only move the fields from the old table that matched the fieldnames in the new table.
I could write a short program to do it for me, but I thought that maybe there was an easier way than that because it's only for two records with about 40 fields in each record.
Manually entering the data might take 30 minutes to an hour I estimate because some fields are memo fields.
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site:
www.stephenkramer.comWould you believe Far Side Lite?
More than 270 original cartoons.