Insert a row

[AnnPhil]

I have a database that is tracking proposals and job orders. First the proposal goes out and then sometimes the customer what to change the order in some way which means i need to put a new row somewhere other then the end of the record. I know in Access you can not add a row in the middle of a table but everyone was use to doing this in Excel and was able to make such adjustments. I thought about adding a Sort column so the data entry person could add their own sort order but some proposals can be hundreds of lines and no one wants to do this, however they want to be able to make changes and adjustments to the existing proposal. Is there some magic I could create in the development of this database to make everyone happy?????

Any suggestions greatly appreciated.

 

[deBassMan]

Hi there

I'm having difficulty understanding you.

First of all you should not be enabling users to add/edit rows directly in a table - use forms and sub-forms.

Each customer would have a unique ID and the sub-form could display the related orders.

Secondly, are you storing hundreds of rows of data per record?

May I respectively ask how much experience you've had with Access?

cheers

 

[AnnPhil]

Each customer has a unique ID and the data is being entered and edited in a subform. If a customer orders 75 items, there will be 75 rows. Each item ordered will have a record in the subform. This is a proposal so often times the customers reviews it and then decides to order something else or not to order an item. Other then re-entering the entire order we would like to update the order and send it back to the customer for approval. I have 10 years experience with Access and this is the first time i have had this come up. Most cases adding a new record at the bottom has not been a problem but this group wants to keep certain items together. I could probably add a category table and group things by category and then we could group by cateogory but i was hoping not to restructure the database.