Creating an "Insert Record" Button

[ZachAtaiyan]

Good Morning Everyone!



Now before everyone jumps on me for this, I do know the difference between a spreadsheet and database table. However, for all practical purposes, I need your assistance in tackling another issue...

Currently, I have a form that will be used to do component inspections on Tablet PC's. The plan is to fill in the forms with as much data as possible before arriving on site to reduce the time required to do these inspections. This includes the creation of records that we expect to be on site before we arrive. One of the concerns is that on some inspections, they may have not anticipated a component (Record) when they were doing the pre-entry, and will want to group this component (record) with the similar records. However, if a new record is created, by default it is added as the last record in the table. I am looking for a way to "Insert" That record among the similar records so when the report is published, everything is grouped properly.

From my search of existing forum posts, I see that the data can be queried to sort things how I would like, but I would need to define a new field to act as a primary key.

Are there any other ways to do this that you guys can think of?

Thanks in advance!

[ranman256]

It doesnt matter if the record is added 1st, last , or in the middle, ....you sort them how you want. Throw it in the toy box, then sort by key, or name, date, etc.
Usually NOT by primary key # if its just a counter.
Counters can only show the order it was added.

[ZachAtaiyan]

Does anyone have a good sort procedure if I wanted to sort by FS, FA, LS categories? For instance each file would be associated with an ID of one of these tags; FS003, FS004, FA005, LS001, FS202

[ZachAtaiyan]

Would the way you sort something appear in the order on the form? for example, if I have 70 records, and I need to add one and have it go between 23 and 24, I can create a sort order that will take care of it, but will it show up that way on the form?

[June7]

If you want to sort by categories, need a field with the values (can be calculated).

Don't rely on sort saved with table. Set filter/sort criteria in query or properties of form/report.