How to create text fields dynamically?

Is it possible to autofill fields in access using SQL to code?

• Hi, I'm working on a project that uses access to create a database using SQL. Here is the code that I am using to create one of the tables: CREATE TABLE Exercise_Classes ( Class_ID AUTOINCREMENT(1, 1) PRIMARY KEY, Exercise_ID INTEGER REFERENCES Exercises (Exercise_ID), Date_of_Class DATE, Time_of_Class TIME, Instructor_ID INTEGER REFERENCES Instructors (Instructor_ID), Member_ID_If_Applicable INTEGER REFERENCES Members (Member_ID), Surname TEXT, Forename TEXT, "Liked?" VARCHAR (1) ); Is there a way to make it automatically enter in the Surname and Forename fields when a member id is entered? Thanks

• Answer:

  There is no need to write the Surname and Forname in the Exercise_Classes table, because you're already linking to the Member_ID. You can use a look-up combo-box to retrieve the corresponding member name. Otherwise what you intent to do will duplicate the storage of member name, and so you need to update two records each time the name is updated.