Auto Filling User Details - Homeless Shelter

[lk12]

Hi guys,

I have been managing a database system for a homeless shelter in my volunteer role. There is a certain feature that would help improve accuracy of the inputted records, as well as freeing up time for staff. That is - auto filling a user's Gender and Nationality when inputting a record for the drop-in centre.

Currently, when a forename and surname is inputted in the "DropIn_Input" form, it is checked against the stored 'service users' table and checks for the name combination. If the name combination is not present then the forename and surname fields change to 'New'.

What I would like is to keep this, but if the service user name is stored in the 'Service User's table then I would like their Gender and Nationality to be automatically filled into the fields on the 'DropIn_Input' from the relevant information in the 'Service Users' table.

I have researched this and tried for a long time unsuccessfully. I have attached a sample database, can somebody please help me with this?

Thanks,
Paul

 

[lk12]

Any idea guys?

 

[Mihail]

I think that will not be ideas.
In my opinion this is not a DB.
There are some collections of data not related between them (at least I can't see any relationship between tables).
So for everyone is very hard to understand your "DB".