Do you have two tables, one with a list of members' names (and presumably their ID number) and another that lists lots of actions. When you enter an ID number in the Actions table you want it to automatically enter their name in the 'Name' field , but if they are not listed in the Members Table then you want to type their name?
That is easy: in the Action Table create a MembersID field and a MembersName field. Create a relationship between the two tables using MembersID.
When you create the MembersName field in the Actions Table make it type 'text' and on the auto-enter tab of the field options tick 'Looked-up value'. Define the value to be looked up as the MembersName field from that relationship to the Members Name Table.
If you enter an existing ID number it will insert the name correctly. If the ID number does not exist you can enter it manually.
Thanks Sorbsbuster I'll give that a try but I will be busy for the next couple of days but I will get back to tell you how I went.
What an Idiot I feel. I knew the solution in fact I had done the same thing on another database but what threw me was I didn't think I could edit the fields but I never tried. Thanks for the help