Count the record in subdatasheet

[Faiz12]

I'm trying to count the number of records in the subdatasheet for each equipment ID and put them into total clients field automatically. For example the Equipment ID 1 will have 1 in its total clients field while Equipment ID 2 will have 2 in its total clients field since it has 2 record in its subdatasheet if that makes sense

[June7]

Tables don't work that way. Would need code to save this data into Total Clients, however, should not save aggregate data to table - calculate when needed. Build queries and/or report using Sorting & Grouping with aggregate calcs.

Strongly advise not to use space in object naming convention. Also advise not to work directly with tables and queries for data entry and viewing - use forms and reports.

[mike60smart]

Also it is advised NOT to allow Datasheet View

[Micron]

Also it is advised NOT to allow Datasheet View

You must be referring to a form, so why not?

[mike60smart]

My apologies Micron, I meant to say Subdatasheets

[Micron]

My apologies Micron, I meant to say Subdatasheets

NP. IMO they're only useful for testing during development. If one follows the unwritten (?) commandment about not allowing users into the tables, then they're of no consequence.