What is the best way to represent a One to many in forms (1 Viewer)

[Thinh]

I have an input form that has many (one-to-one) fields in it, i also have one field that is a one-to-many relationship in there. I dont know how to break it out of the form. a subform would solve the problem but a subform for one record worth the efftort and how would it actually look like. I need suggestion on how the subform or the general structure of the database. i understand funtion dependency and normalization just have hard time picture how it would look like in a form.

Thanks in advance

 

[KeithG]

a subform would solve the problem but a subform for one record worth the efftort and how would it actually look like.

I would suggest a subform. If it is only going to have one record should your join be a one to one? You don't need to set your subform in datasheet view instead use form view. Then you can't even tell it is a sub form.