Information from database or entered info
The answer to my question would more than likely be here but as for how to search I wouldn't know.
My question, I have a database that records action of non members who we don't record anywhere and members who are on a seperate database. I want to have several fields but the main one is the member so if it has a number entered manually it goes and puts the members name in the other field but if not this field has to be inputed manually.
I want the name field to do two things be inputed automatically from the number in another field or manually if a number is entered in the number field.
I know how to link the fields to look at another database but not the two actions I require.