Ripper Idea! How does it work?

[Greg Smith]

G'day,

Feel like a Galah however I need to kick this problem into touch before sundowners this arvo. Could someone explain the following which I have cut and pasted from another post. (Tried that UBB stuff but was out the back with a didgeredoo). It would help a lot if I could have the lil nipper version as obviously I have a lot to learn WRT jargon & FM

"Actually you're close to what my other method would be, which is to use what I call a relationship pipe. Basically, I create a relationship such that it is never valid. In my local file, I use a constant field set to 1, and in the foreign file I use a number field (usually called Temp_Relationship) set to auto enter a 0. The relationship is set to allow the creation of related records.

Then you can use a statement like:

Set Field [ Relationship_Pipe: ummy, "X" ]

Set Field [ People_ID, Relationship_Pipe::People_ID ]

Set Field [ Relationship_Pipe::Temp_Relationship, 0 ]

The first set field creates a record in the foreign file. This happens because there is never a valid related file and because I've allowed the creation of related records.

The second set field gets the People_ID value from the new record using the temporarily valid relationship and sets that value to the local People_ID, creating a valid relationship using that field.

The last set field breaks the pipe so that there is again no valid related record in the Relationship_Pipe and the next time I use it I can do so to create a new record.

Chuck"

I have a database "Flight Data" which records ten or so parameters. These are identified by a auto entry sequence field (no modification allowed). I want to transfer this auto sequence number into a minimum of three and upto five seperate Files (separate databases) "Landings", "Route", "Instrument Flight","Fuel","Oil". A single flight may involve mutiple records in "Landings" (due to different Locations) and "Fuel". I think this method is a beautie but am unable to nut out the track to make it work in my application. Any ideas. My local mate, who reckons he is a bit of a wizz, hasn't the foggiest. His comment is "that staying sober at Birdsville on race day having walked the track to get there, would be easier. Copy & Paste."

Any Ideas?

Ta in advance, Smithy