Auto Enter Field??

[Jared867]

Hi I am not sure if this would be the right area of teh forum to ask this question but honestly I didnt know what section to start in.

My question is this:

I have a simple database that i built to keep track of an inventory. For the last year I am the only person who has entered any stock into this database. Now I will be training someone else to enter stock into the database. What I would like to do is when this person enters a record into teh database, that a field will be auto filled showing which account last edited the field and/or entered the record. I have looked and I dont see where I would do this at. Any help would be greatly appreciated.

[Jessica_BLUE]

there's an easy way to do this, with a value list (drop down box)select all the part numbers of your inventory, also create a field, which does not have permission to be entered (behavior). this 2 tables must be related, so when select a stock in the drop down list, the other field automatically fills out with the relation,at this point works if only you want to show the last accesed account,if you want to save the record now in this field, setup set field with target field the field you wanna save and the calculated result with the related field.

[Jared867]

hmm my inventory doesnt actually have stock numbers... well it does but they are constantly changing. the database I run is a database of a used motor inventory. every record has its own unique stock # and every new field entered has its own new and unique stock #. There are about 3000 records currently. When we sell an item the record is just deleted along with its stock # and its stock # is never used again.

So with that in mind, it doesnt sound to me as if the method you layed out above will work for me.

there is no other way?

[comment]

Why don't you simply define a text field to auto-enter modification account name?

[Jared867]

id love to. thats exactly what I am wanting to do but I am completely stumped and cant figure out how to do this. I define a text field but then I dont see where I would "auto-enter modification account name" please help me?

[Jared867]

Ah ha! I found it! lol thank you :)