Insert rows in Access Tables

[rayp0614]

I have a form and subform in my database. Users enter data in the subform in a sequential manner. If a user wanted to go back and insert a row on the subform to maintain the grouping, what's the best way to approach this?

Example
Category Price
Door1 $
Modification1 $
Door2 $
Modification1 $

I want the user to be able to enter a Modification2 with Door1 and maintain the grouping for the user.

Thanks
RP

 

[allanon]

If I am not mistaken, whenever access adds a row to a table it is always at the end. You would have to set up the table and the data to order it how you need it. ie: key on category. Then you could add whatever rows you need and display it and group it how you need it. It may be neccassary to add a unique key such as an auto increment to keep the records unique.

 

[allanon]

If I am not mistaken, whenever access adds a row to a table it is always at the end. You would have to set up the table and the data to order it how you need it. ie: key on category. Then you could add whatever rows you need and display it and group it how you need it. It may be neccassary to add a unique key such as an auto increment to keep the records unique. Then to order it you can just do something like:

SELECT EXAMPLE.CATEGORY, EXAMPLE.PRICE
FROM EXAMPLE EXAMPLE
ORDER BY EXAMPLE.CATEGORY

Just A note though. I think I would have set up the table:

KEY Auto Increment
CATEGORY TEXT
DESCRIPTION TEXT
PRICE Currency