selected field or fields to sort records
Since your question is extremely open ended, look at the tutorial (click on the related link). Before you post you inadequacy to the world, try Google.
List and Display in FoxPro are almost the same exact thing, the only difference being that List will show all of the records continuously, while display will only show the records until the screen is filled, with a button at the bottom prompting you to, "press any key to continue".
The answer would be form.
To display the total number of records in an opened table, you can use the SQL query: SELECT COUNT(*) FROM [table_name]. This query will return the total number of records present in the specified table.
Sort?
Seymour Jacob Pomrenze has written: 'Selected readings on records management' -- subject(s): Business records, Management, Records
select * from tablename
Filter by selection
There is no definitive answer to that, as it depends what you want on the form. Ultimately all data comes from tables. If you just want to show all the records as they are you could base the form on the table. However if you want to display only selected records or certain calculations, you might create a query to do those operations and then base the form on the query.
Archives are historical documents that have enduring value and are preserved for research and reference purposes, usually by institutions like libraries or museums. Records are documents created or received in the course of everyday business activities, providing evidence of transactions, decisions, or activities. Archives are typically a subset of records that have been selected for permanent preservation.
you have to mix records