FMPRO-L Archives

November 2010, Week 3

FMPRO-L@LISTSERV.DARTMOUTH.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
John Raid <[log in to unmask]>
Reply To:
FileMaker Pro Discussions <[log in to unmask]>
Date:
Mon, 15 Nov 2010 10:24:56 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (26 lines)
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

ATOM RSS1 RSS2