Gossamer Forum
Home : Products : DBMan : Customization :

Insert Record between records

Quote Reply
Insert Record between records
Hello:

I've been playing with DBMan for possible use with an application but I need to be able to insert records between current records. Here's the scenario:

1. Client logs in to DBMan backend.
2. Goes to "Add" (the insert could be done in "Modify" also.)
3. Form appears which allows for a new record to be appended or inserted between records.

Is their a DBMan mod or can DBMan be customized to insert a record between two records from the "Add" page or "Modify" page? The new DBkey would need to appear(as it doesn in "Add"). This might make more sense from the "Modify" link where the client performs a search for a specfic month and wants to insert an event between two events in the DB on different days. Hope this makes sense.

Thanks
Doug
Quote Reply
Re: [D0ug] Insert Record between records In reply to
If you're sorting by date, you need to have a field where they enter the date. Then it's no problem.

One of the basic concepts of database design is that the order of records in the archive is unimportant. If there is a reason to display the records in any specific order, there must be a field for the records to be sorted by.


JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.