🚀 go-pugleaf

Isaac wrote:

> Hi Bill,
> This table is a detail table hold items for each inventory (master
> table) the primary key consist of "inventory code" and "item code"
> for some reason customers need the item code to repeat for each
> inventory not to be unique all over the table also I already made all
> my logic based on those two fields , so I hope if there is a way to
> get unique value for field "item code" on multi user environment

For one inventory code  suppose you have records with the following
item codes.

1
2
3
4
5

I assume that if you insert a new record it would get item code 6.

If you delete the record with item code 3. What are the item codes for
the remaining records?

Once you answer this question I can tell you how to get the row number.

> 
> Thanks
> 
> BTW: Is there a problem in the news group server many times I get
> post message refused and I dont know whom I should report this to

AFAIK the newsgroups are working properly. I have not had any problem
posting and I have not seen compaints from anyone else. Are you
connecting to newsgroups.borland.com?



-- 
Bill Todd (TeamB)