Mime-Version: |
1.0 |
Sender: |
|
Subject: |
|
From: |
|
Date: |
Mon, 15 Nov 2010 10:24:56 -0500 |
Content-Type: |
text/plain; charset="ISO-8859-1" |
Content-Transfer-Encoding: |
quoted-printable |
Reply-To: |
|
Parts/Attachments: |
|
|
Hi all,
I inherited a FM file with a table with owners and a linked by IDkey vehicle
table.
Linked to the vehicle table are several other tables like maintenance,
accessories etc.
All made in FM4, now converted to FM11 (and still working).
I have to add a functionality so that a 'vehicle' can change from 'owner'.
What is the best (easy) way to do this, without losing the history of the
linked tables on maintenance etc?
Now I have zkp_customerID and zkf_vehicleID as key fields.
Is it safe to just add a second vehicleID value to the zkf_vehicleID and
make a sort of multi-key value of it, return separated?
Or will I work myself in a corner.
I was thinking to just add a second, or several, vehicle key values to the
zkf_vehicleID by script....
Solutions appreciated.
Tx
|
|
|