On Jan 19, 2008, at 4:07 PM, Nicholas Geti wrote:
How do I add additional records to a child (related) table from a
master table. These tables are related on the Invoice Number field
in each table and I can add one record just by doing SetField() on
the child's invoice field but if I issue the command again it
simply writes over the previous one as expected. How do I force
creating a second record having the same invoice number?
Use a script in the child table to make new records;
Use a script in the child table to import from the parent;
or, have a portal in the parent table to the child table that allows
creating records, go to the last portal row, then create your child
record by doing the SetField().
Those are 3 ways off the top of my head.
geoff