L
Lou
Please can some help me with MICROSOFT ACCESS 97.
I have a table which contains JobOrderNumber and is the
Primary Key; indexed
and NO Duplicates. This table contains Name, Address,
Telephone ... etc.
I have also another table that is linked to the
JobOrderNumber, but allows
duplicates, so that it an have a number of line items
such as, description,
number of items, price ... etc.
HOW DO I
As the customer has many repeat orders, how can I COPY a
specific
JobOrderNumber and its associated sub items list, so that
all I have to do is
to change the JobOrderNumber, [and amend any slight
changes to the items],
then append them to the databases as a new order.
I have a table which contains JobOrderNumber and is the
Primary Key; indexed
and NO Duplicates. This table contains Name, Address,
Telephone ... etc.
I have also another table that is linked to the
JobOrderNumber, but allows
duplicates, so that it an have a number of line items
such as, description,
number of items, price ... etc.
HOW DO I
As the customer has many repeat orders, how can I COPY a
specific
JobOrderNumber and its associated sub items list, so that
all I have to do is
to change the JobOrderNumber, [and amend any slight
changes to the items],
then append them to the databases as a new order.