making data entry form with subform

[mishafljin]

Hi,

I have to make an form but it doesn't work the way i want it to work..
I'll try to be clear as possible and left out some non-important data and columns.

I have three tables.
1. os_tbl (osID, OS [eg. Linux, Windows])
2. ver_tbl (verID, Version [eg. 7, 8, 10], osIDfk)
3. name_tbl (nameID, Name [eg. Mark, Jane, Tom], verIDfk)



So, what i actually need is to have a entry dana form containing Names of people, and two subforms: OS and Version.
I believe thats simple but i cant make it even with form wizard.
I would like to view data in that tables, and also to make new records on the same form (type in new name, choose OS from combo box, and type in new version).
So in fact, when making new record it must save new Name in name_table, save new version in ver_tbl and connect it. os_tbl needs no data entry or change.

thanks for any help

 

[Ranman256]

I don't see the need for a sub form here.
With names, why do you need 2 lookup tables of OS, and Ver?

Sub tables are to show parent-child records. What are these?

 

[Grumm]

Agree, just make one main form, and put dropdown lists or combobox to select the correct OS or version.
I guess that you want to limit users to create their own operating system.
And if they use some kind of Chinese ripoff IOS, add a record "Other OS".

 

[mishafljin]

thanks.

I asked because i've been told that i will need a form and subform, so I started with it and got many errors.
I'm going to listen your advices then and try that way.