Prev: Query to add fake records from table
Next: Odd Parameter request in Crosstab
From: ErikFM via AccessMonster.com on 23 Mar 2010 16:00
Thanks, Gerry!

I did something similar in house for small team of 4 analysts... time to ramp
up to the tune of 40 branch offices! =)

Jerry Whittle wrote:
>The autonumber PK is a good idea. Adding +1 to the highest number sounds like
>the way to go. One fly in the ointment is if multiple people can be adding
>similar records at the same time.
>
>Depending on when the +1 is figured, like at the start of the record entry,
>more than one record could have the same Branch/Receipt Number. You
>probably also want to make the Branch and Receipt Number field combination a
>unique index.
>> Thanks, Jerry!
>>
>[quoted text clipped - 31 lines]
>> >>
>> >> Thanks!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201003/1

First  |  Prev  | 
Pages: 1 2
Prev: Query to add fake records from table
Next: Odd Parameter request in Crosstab