Re: Forms 4.5 Creating a Record Question

I know of no way in which a new record can be inserted before the first one within a block. However, I wonder why it actually matters at all. Is it not the order in which records are later retrieved from the database which matters. As long as the record entered will be re-queried as the first record, does it really matter whether it happened to be either the first, middle or last record entered. If your ORDER BY clause is correct for the block, I'm sure things will be OK.

i.e. supposing a block was ordering by ID and five records were currently in the table with IDs 2 4 6 8 and 10. If the current record is the 'first' displayed i.e, ID 2 and I press 'Insert Record' I can insert a record with ID 1 (say) as the new second record and it will stay there (as the second record) until a re-query is perfomed. However when the wuery is run it will come back as the first displayed record of the block.

Hope this explanation is what you're looking for. If not, supply some more info on what you're up to.

--
Alan D. Mills


Jenny Farnham wrote in message <6mrsab$goa_at_lace.colorado.edu>...


>In a multi-line block or "detail block", I am


>pressing the insert record key. When I do this

>a blank line appears beneath the line I am on.

>

>This is fine most of the time. However, there is

>a time when the user will be sitting on the FIRST

>record of the multi-line block and want to insert

>a new line ABOVE or BEFORE the first record.

>

>WE are trying manage line numbers and for 99% of the

>data entry we have it nailed down. Its only in the situation

>I just described where we can't get a line inserted visually

>before the first line in the multi-line block.

>

>Any ideas?

>

>Jen

>