When it comes to VBScript and ArcGIS, do what Nancy does, "just say no." Model Builder has its place, it just isn't in my toolbox. I encourage you to learn Python, it will open up ArcGIS to you much more than Model Builder, and the skills are infinitely more transferrable.

The following should work for you. Just paste the code into the interactive Python window and call the add_table_names function with the geodatabase in question. The script will find all tables and feature classes not in feature datasets and append the name of the table or feature class as a new field. If you want to recurse into the feature datasets, it isn't too hard to update the code.

To calculate the field with the feature class name, you need to parse the feature class path. Parse Path is available as a model-specific tool. You can also use Iterators inside the model to loop through each of the feature classes.

EDIT: You could also use the NAME variable in iterator, instead of PARSE PATH.

When it comes to VBScript and ArcGIS, do what Nancy does, "just say no." Model Builder has its place, it just isn't in my toolbox. I encourage you to learn Python, it will open up ArcGIS to you much more than Model Builder, and the skills are infinitely more transferrable.

The following should work for you. Just paste the code into the interactive Python window and call the add_table_names function with the geodatabase in question. The script will find all tables and feature classes not in feature datasets and append the name of the table or feature class as a new field. If you want to recurse into the feature datasets, it isn't too hard to update the code.