setting up input boxes?

[jacko999]

Heres my problem i need to create a data base with the field called software. this needs to be input on my form but there can be more than one and they need to be input into my form. was thinking of having a txtinput and a number that inserted brings up the amount of txt boxes specified and the stored in my tables. so i need to know:
1. how to do this
2. how to setup the tables to accept data this way

anyone have any idea?

Chris

 

[Ed2020]

You need two tables - one to contain the main record, and another to store the related "software" records. These two tables will have a one to many relationship.

In terms of the data entry form I would either use a bound form with a sub-form to display the software details, or an unbound form with a listbox to display the software details.

Hope this is of some help...

Ed Metcalfe.

Please do not feed the trolls.....