Two Entries on an Input Form

[Guest]

I am trying to create an input form for a lovingly well-normalized law firm
alumni database. I have created an input form that allows you to add fields
for each new alumni, but I can't conceptually figure out how to make it
possible to add multiple values for a given field. For example, if the
alumni has two new "JobTitles", how do you enter these? I have the database
tables set-up as a 1 to many relationship, but how do you go about entering
this info with a form?

 

[Keith Wilby]

I am trying to create an input form for a lovingly well-normalized law firm
alumni database. I have created an input form that allows you to add
fields
for each new alumni, but I can't conceptually figure out how to make it
possible to add multiple values for a given field. For example, if the
alumni has two new "JobTitles", how do you enter these? I have the
database
tables set-up as a 1 to many relationship, but how do you go about
entering
this info with a form?

By "add fields" I assume you mean add records. Include a subform onto your
form which is bound to the table at the "many" side of the relationship.
Thus, for each record on the main form you should be able to enter many into
the subform.

HTH - Keith.
www.keithwilby.com

 

[Guest]

My bad, I meant records, not forms. I will look into subforms. I've been
asked to recreate my company's relational database, in spite of the fact that
this not my area. Thanks for the tip. grumble grumble.

"Keith Wilby" escribió:

 

[Guest]

I've got a handle on subforms now, but now I have another problem. The users
can access the subform, but how can I set it so that they can alter the list
of values to add a new record options. The record options are coming from a
linked table.


"Wynn" escribió: