A
apedersen
Hello,
Here's what I'm trying to do.
I've got a flat-table database - BridgeTranscript - into which I'm
transcribing the footage I'm shooting for a documentary.
I've got a nice continuous-list form - Bridge Search - through which I
can enter search terms for each of Bridge Transcript's eight fields.
I've also got a button on each of the records which Bridge Search turns
up that, when clicked, writes that particular row into a second table,
Sequence, and spawns a second form - SequenceForm - that displays
everything in Sequence.
Everything works to this point. But I'd like to take it a step or two
farther.
Essentially, I want to be able to gather the best clips from Bridge
Search (each row is a clip) in Sequence and then rearrange them into
the editing order.
I know that databases don't naturally place data in any sort of order,
and I'm trying to figure out how to impose my own order on the data in
sequence. Using the Primary Key from Bridge Search won't work, because
I want to rearrange them. So I've set up an extra field in Sequence
called sortkey.
My first big stumbling block, though, is this:
I'd like to be able to select a record in SequenceForm so that when I
hit the write button on Bridge Search, it will write the record
immediately below the selected record.
Thing is, I can't figure out how Bridge Search can figure out which row
has been selected in SequenceForm, and what its sortkey value is. I've
tried a
I think that once I've cracked this, I can muddle my way through the
coding that will then update all the sortkey values in SequenceForm so
I can keep control of the order in which they're displayed.
Thanks in advance for any help.
-Andy
Here's what I'm trying to do.
I've got a flat-table database - BridgeTranscript - into which I'm
transcribing the footage I'm shooting for a documentary.
I've got a nice continuous-list form - Bridge Search - through which I
can enter search terms for each of Bridge Transcript's eight fields.
I've also got a button on each of the records which Bridge Search turns
up that, when clicked, writes that particular row into a second table,
Sequence, and spawns a second form - SequenceForm - that displays
everything in Sequence.
Everything works to this point. But I'd like to take it a step or two
farther.
Essentially, I want to be able to gather the best clips from Bridge
Search (each row is a clip) in Sequence and then rearrange them into
the editing order.
I know that databases don't naturally place data in any sort of order,
and I'm trying to figure out how to impose my own order on the data in
sequence. Using the Primary Key from Bridge Search won't work, because
I want to rearrange them. So I've set up an extra field in Sequence
called sortkey.
My first big stumbling block, though, is this:
I'd like to be able to select a record in SequenceForm so that when I
hit the write button on Bridge Search, it will write the record
immediately below the selected record.
Thing is, I can't figure out how Bridge Search can figure out which row
has been selected in SequenceForm, and what its sortkey value is. I've
tried a
I think that once I've cracked this, I can muddle my way through the
coding that will then update all the sortkey values in SequenceForm so
I can keep control of the order in which they're displayed.
Thanks in advance for any help.
-Andy