Generating field based on user entry

[farscp1]

I have a database that I would like to enhance to make data entry user friendly. The database collects information on faculty. The main form has a section of faculty education. Some faculty may have two or more degrees. I would like to have the user key in a value X which will equal the number of degrees and information to be enter; degree, year, institution, state, college, department, area of study. I think this would bed more efficient than creating 10 rows and the faculty member has 2 degreesor more than 10.

I appreciate any information.

Farscape1

 

[JoeAtWork]

I think you should create a separate Degrees table and relate it back to the Employees table (or whatever you call that table). Then the faculty member could have 0 to infinite number of degrees.

You could make a main form for the Employees table, and a subform for the Degrees table. The subform could be set to repeating forms.

 

[TheAceMan1]

How are ya farscp1 . . .

Agree with [blue]JoeAtWork[/blue] on the additional [blue]Degree Table[/blue].

Instantiated on [blue]the many side of a relationship[/blue], [purple]as a continuous subform[/purple], user could easily enter as many degrees as the individual has aquired.

Your thoughts?

See Ya! . . . . . .

 

[farscp1]

Thanks for your feedback I will try and post soon. Thanks again. Anna

 

[farscp1]

Thanks for everyone's feedback. I set it up as a continuous form and it works fine.