ddmcn
Registered User.
- Local time
- Today, 13:29
- Joined
- Sep 12, 2002
- Messages
- 73
I am trying to find a way to "insert" a record into a table that will not put the new record at the end of the table but insert it into the middle of the table. For example, let's say that I am keeping track of officers of a trade association. The association has a president, a number of vice-presidents, and a number of secretaries. The list might look like:
President John Williams
Vice President Tomas Dojaric
Vice President Lillian Berget
Secretary Robert Bruce
Secretary Kim Jeung Tao
Now... I want to add a new officer...who happens to be a Vice President. If I insert his/her record it will appear at the bottom of the list. But I want it to appear at the point in the list where the other Vice Presidents are. I have thought about a button to move the record up in the list...but then I don't know how to re-number the existing records.
If I haven't explained this too well, let me know.
TIA
Dennis
President John Williams
Vice President Tomas Dojaric
Vice President Lillian Berget
Secretary Robert Bruce
Secretary Kim Jeung Tao
Now... I want to add a new officer...who happens to be a Vice President. If I insert his/her record it will appear at the bottom of the list. But I want it to appear at the point in the list where the other Vice Presidents are. I have thought about a button to move the record up in the list...but then I don't know how to re-number the existing records.
If I haven't explained this too well, let me know.
TIA
Dennis