Good day. There is a table in MS Access, in which there is a numeric field "face value", and there can be more than one record with the same face value. You must create a form on which there must be two fields. One field displays a list of entries for this table. When clicking on a record, records with the same rating as the highlighted record should be displayed in another field. I ask for help, I can not figure out how this can be implemented.

  • Do you need a SQL query that selects fields with the specified denomination? - pavel
  • I myself can write the request myself, thank you. I don’t understand how I can select the records I need through the form - Ron de Pooh

1 answer 1

You need to make 2 subforms in the form. One contains your records, and the other contains the same records, but with a filter on the selected nominal value from the first form.