Inventory ID mismatch

[jimmydreams]

I am using an inventory database. When I add a new item and then sort, the item goes alphabetically to the list as wanted but the Inventory ID # doesn't adjust to the new position and gives it the number as the last entry. How do I coordinate the ID # which is auto to reflect the new 'sorted' position of an item. Thank you

[The Digital Man]

It sounds like the field may not be from the correct table. I am guessing here. In layout mode on your list layout go under layout > layout setup and look to see what table occurence is listed for "Show Records from". Then double click on the ID field and make sure it is from the same table occurence. You could also double click on the Inventory Name field - NOTE WHAT TABLE occurence it is being displayed from and make sure the ID field is also being displayed from the same table occurence.

 

Now if you are not using Filemaker 7 than ignore everything I said.

 

Good luck.

[Ender]

I think what you want here is not the Inventory ID, but a sequential numbering of the records on the layout. This can be done easily by typing @@ in a text area in the Body part on the layout. The numbering will happen automatically when viewed in Browse or Preview Mode.