Payment control in access

[Javier]

Good Morning. Excuse my ignorance, but do you think it would be possible to control payments in access for a school? What I need is that when a student pays in January, for example, they present it to me as paid, otherwise as pending. I will attach the file. Thanks in advance.



https://mega.nz/file/gsNxEDAa#Yzmpu1...rrQrocv3bElRbE

Buenos días. Disculpen mi ignorancia, pero Creen que seria posible hacer un control de pagos en access para una escuela? Lo que necesito es que cuando un estudiante page enero por ejemplo me lo presente como pagado, de lo contrario como pendiente. Adjuntaré el archivo. Gracias de antemano.

[isladogs]

Yes. I have a commercial app for this School Payments System (isladogs.co.uk)
Sorry but I haven't looked at your file

[mike60smart]

Hi
Took a quick look at your database and it makes no sense to me as it is in Spanish.

The Relationships make no sense.
You are using Lookup fields in your Base table. There are a No No in Access.
You should not be using spaces in field names