Columnar Form - Multiple Entry

[finfin]

I am trying to create a data entry form that contains a student's name and contact information. My problem is that for student's phone number, it is a one-to-many relationship where a student can have as many phone numbers as possible, each with a type name (mobile or home).

Pictures below show what I currently have, I wanted to assign 2 phone numbers for John Doe, I would have to repeat the entry twice. (Of course in both entries, they are linked to a common ID, so there is no duplicate record)

In my columnar data entry form, I wish to add a "+" button that when pressed, would create an extra entry box to key in new phone number, and choose a type. I do not want to use a subform with table.
How can I achieve that?

[Homegrownandy]

Just make the form and add a button to open it
It sounds to me like you need a table just for stored numbers.....

something like...

Student_ID - Number - Phone_ID
1 ##### 1
2 ##### 1
3 ##### 1
4 ##### 1
5 ##### 2


then your phone_ID relates to either mobile or land line in a different table.

This could be a drop down on your new form..

Hope this helps. let us know.

edit:

It could potentially look like this and allow you to add as many numbers as you like.

Student_ID - Number - Phone_ID
1 ##### 1
1 ##### 2
1 ##### 1
1 ##### 1
1 ##### 2