On 30 May 2007 at 11:51, Chris Monahan wrote: > This is one of the reasons I dislike the Base Module so much > > On 30/05/07, Drew Lindhoff <[EMAIL PROTECTED]> wrote: > > I noticed in your Base Module that once fields are entered into your create > > database function that new fields cannot be inserted in-between two already > > existing fields, but can only be inserted at the end of the fields listing. > > For a person like me who is constantly re-ordering the layout of the > > database, this presents a real time consuming problem of having to cut and > > past numerous times to re-order the top to bottom listing of the fields. > > Therefore, a proper insert function would be a real time saver for me. I > > am not complaining. I am just suggesting. > > > > Drew Lindhoff. > > > -- > Chris Monahan >
There is a general principal in ralational databases that the order of columns in a table is not important for the retrieval of data. The facility to create views enables one to present the data in a way that the user requires. So create a view of the base table with the columns in the correct order and use the view wherever it is important to see the data in that particular order. Base provides a design view for creating views (like you have in Access) which even allows you to move columns around, Unfortunately you don't seem to be able to get back into design view to modify a view. So you will have to delete the view and create a new one each each time you add a column to the base table. I really would like to see the design view available when you choose to Edit a view. Tony Pursell --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
