im doing a database system for the sports association at my uni. wat i want to do is that whenever a person makes a payment, it will automatically updata a yes/no box in another table. does anyone know how to do this?
It is considered bad practice to have a field's value be dependent on another field's value when that field is not the primary key. It is better to simply "calculate" the desired result. In this case you need only determine that a payment has been made for any given individual when such payment meets specific criteria. Then, based on this, you can use an unbound field to state this fact.
This is a many to many structure. You'll need an intermediate table to create the join. This table needs foreign key links to the primary key of each table (teams and members). You should probably make these two fields a compound primary key, but don't try to use it as your actual linking keys to the payment transaction table. Instead create a pseudo primary key using an autonumber field. Use this as your join field just as though it were the actual primary key field.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.