Subject: | |
From: | |
Reply To: | |
Date: | Mon, 15 Nov 2010 10:24:56 -0500 |
Content-Type: | text/plain |
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
|
|
|