one to many

[miltiadis21]

Hi i have this form

Which has many to one relationship with The customer ID which is linked with this form

How can i make this form to look like like a continuous one but with empty fields to put many lens for the one customer

I want to make it like the picture that you see. I tried to put a continuous form but it shows all the data and not like it looks in the sub form with a relationship one to many that you can add for one customer many data How i can do this?

Any suggestions , Comments?

Thanks

P.S and how i upload files here?

 

[miltiadis21]

Ok let me rephrase my question... If i had a one to many relationship and i want on the many side of the relationship e.x(one.Client -> many.Products) to represent the data(Products) as a form and not as a subform how i could add many data on the form(Products) for a single client that exists in the one side of the relationship without representing the data as a subform but as a Form for one Client.
"For more info you can see The Second picture that I've allready post"
Thank you all

P.S is this possible?

 

[ajetrumpet]

If you create a one-to-many relationship of two tables (Clients and Products) and actually create an auto-form based on your "one side" table (Clients), it will automatically insert a linked subform into your main form when it's created. This might be just what you need (from what you're describing anyway). Try doing this and see if it is what you need.

If this isn't what you are saying, and if I'm reading the following quote correctly....

I tried to put a continuous form but it shows all the data and not like it looks in the sub form with a relationship one to many that you can add for one customer many data

maybe you just need to change your form to "data entry"??

 

[miltiadis21]

If you create a one-to-many relationship of two tables (Clients and Products) and actually create an auto-form based on your "one side" table (Clients), it will automatically insert a linked subform into your main form when it's created. This might be just what you need (from what you're describing anyway). Try doing this and see if it is what you need.

I tried this solution and the wizard created a link between the two forms and your solution worked fine.The only problem i have now is that the Form in the many side (Products) doesn't hold the values when you close it and doesn't store them in the tables!!! I don't know how to solve this
Thanks

 

[Egg 'n' Bacon]

Not exactly sure what happened with the auto-form you did, but here's an edited DB with a new auto-form (Customer1) that seems to work. You will have to edit it to match your formats though.

 

[miltiadis21]

Thanks for the help Egg 'n' Bacon but i didn't want it to look like a sub form but like a Form
Any other Suggestions?

 

[Egg 'n' Bacon]

You just need to work with the formatting; transparent borders etc

 

[miltiadis21]

You just need to work with the formatting; transparent borders etc

Sorry but working with the formating, transparent borders etc is totally out of topic I just want an answer why the form in the many side which is filtered to show the records that each customer has doesn't store the values in the table

 

[Rabbie]

Sorry but working with the formating, transparent borders etc is totally out of topic I just want an answer why the form in the many side which is filtered to show the records that each customer has doesn't store the values in the table

I think that the suggestion about the formatting was made so you could use a subform which would resolve your original issue. If you don't want advice why do you ask here? Since you think you are such an expert why don't you fix it yourself

 

[miltiadis21]

Thanks for your help guys.Problem solved Thank you all
Wish you the best