Hi,
Please excuse me if this question has been asked before but I could not find
the solution. Is there a way to duplicate a record including related records
that is in another table.

For example I have 2 tables which is order header and order detail.

Albert

It depends a little on how the database is set up. There isn't a one button
solution though. You have to script it. And then the solution is depending
on your version. Pre version 7 you have to use global fields. Duplicate the
record and fill inn all the values that didn't get accross. (Auto-entered
id's and serials for instance

With 7 and up you can use variables to transport the values that get skipped
when duplucating.

your scipt would look something like:
store all data that otherwise would get lost, like serials and id's etc.
duplicate current record (all normal data gets dupolicated)
set id's etc to the ones you have stored previously

Oh and by all means do try the help file and look for duplicate and look for
keyboard commands.

The related info would not be duplicated. It does however escape me how this
would ever properly work, since proper ID's wpould always be unique, to
avoid confusion. My guess is that when you have to duplicate a lot of info
or do a duplicate on a regular basis, that your file is wrongly set up. The
info should be entered once only. Then get accessed through a relation or
whatever other means you need. IMHO you should probably rethink your
strategy.

Ursus


"Albert" <apasion (AT) gmail (DOT) com> schreef in bericht
news:INU%g.37831$975.625795 (AT) weber (DOT) videotron.net...

Thanks for the great help. I am running FM7 and i am trying to find a way to
create same order where my customer would say ship me same order as my last
order.

Albert

"Ursus" <ursus.kirk (AT) wanadoo (DOT) nl> wrote

In this case duplicating the record would not solve your problem.

Just quickly....

Create a customer table, create an order table, link those two
Create a new record for each order the customer makes and link this properly

now with a portal, or a proper layout you can see all the orders your
customer has done, if there is ever a duplicate order you could now
duplicate the previous order. The orderID would automaticly update, the
userID would stay the same.

There are better ways to do this, and it would only be of any use when
duplicate orders happen all the time.

Ursus

"Albert" <apasion (AT) gmail (DOT) com> schreef in bericht
news:0q10h.9270$PD.6718 (AT) wagner (DOT) videotron.net...