How to connect user details for registration to login form

See more:

VB

MS-Access

Hello Developers

I would like to have someone's help, I have a problem of how i can get tables updated automatically through the relationship I've done and then I would like to know the function used in access to make calculation, like I would like to make a calculation of fine in terms of hours means after overdue date has occurred that the charge has to be count by itself concerning the money for long loan 500shilings and for short loan 200sh. thank u



The second question is about how I can connect the table that will hold user details to staff table(logintable) and role table, now I m using staff table wich is connect to login interface, it has username,password, RoleId, and role id has Roleid and Role.
in user details table i m having firstname,surname,lastname, RoleId and address,But I don't know how I can connect them, so that through user details table can hold the information that the staff table will be using, basically to help user registering with the system for use.

Please help me out.

Thank u