Adding a counter?

[jeleal]

Good afternoon all, I am still relatively new to FileMaker and I have a question. I've built a nice little DB for my movie inventory (I didn't use the one provided as an example, go me!) and I'm trying to institute a counter. Basically I'm looking to have a field in my layout somewhere that will show how many actual records I have.

 

I would think this is brainless, and I'm sure it is, but I can't seem to figure out how to get a counter into my layout. I'd like it to just display how many records (movies) I have, and of course add to itself when a new movie is input into the system. Anyone have any ideas?

 

Thanks for your help!

[jeleal]

Just wanted to mention. I did figure out how to put a record NUMBER in to the layout, which will tell me what number a certain record is, but that's not what I'm looking for. I'm looking for a cumulative field. I know I can see the number of records on the sidebar, but I have the db set up to remove the sidebar when not on the administrative area of the db, which is where I add, edit, or remove movies/records. I would like something to appear and say "Number of movies so far: 400" or whatever. Thanks again!

[AHunter3]

Calculation field, result type = "text", defined as

 

"Number of movies so far: "& Get(TotalRecordCount)

 

 

 

Storage set to "unstored / calculate as needed"

[jeleal]

Hey thanks a lot for the quick response!