Linking fields in microsoft access?

hey, i'm creating a database in microsoft access and i have 3 fields in a table that i want to link together... there called 'total cost of order', 'amount paid' and 'amount still owed'. is there any way for me to link them together so that when i enter a value into the 'total... show more hey,
i'm creating a database in microsoft access and i have 3 fields in a table that i want to link together... there called 'total cost of order', 'amount paid' and 'amount still owed'.
is there any way for me to link them together so that when i enter a value into the 'total cost' and the 'amount paid' fields, the 'amount still owed' field automatically updates?
thankkss :)
2 answers 2