Status update

[Nishikawa]

Hi,

I badly need help. I have two table (Product & Comments)that are connected by a one-to-many relationship. The Comments is a table where people can put multiple comments for one product. If a comment is added, a special status field will be changed from "No" to "Yes"

This special field is joined with the product table in a query. This query is used in the a form.The reason is that if user notice that the special field is changed to "Yes", they will click to view the comments added.

The problem is that when a product have two or more comments, the form will display the product twice (it is in datasheet view) and if I grouped the products in the query. I am unable to edit any details of the product in the form.

Can anyone help me please?

 

[Guus2005]

Use a form containing the main table Product and a continuous subform containing the comments. This way you can edit both. Do not join these.

 

[Nishikawa]

The comments is a stand alone pop-up form. The special field is just a indicator for user to know that comments are added for the specify products.

Both table are join in the ERD. Therefore, when both table are added into a query, they are already connected.

 

[Guus2005]

Remove the automated link. Not the link in the ERD but in the query you are making. You will find that they are not connected.

For more help, post your db or a subset describing the problem.

 

[Nishikawa]

The attached is the scaled down version of the one that I'm building. Click on FmDisplay to see the main form that will be used by my users.

If you click on "O/B" that is marked as "Yes", a pop up form will be displayed.

Main problem is that Product Code and Cat Code can only be edited if the Query "05DisplayScheduleInformation" is not "Grouped", but if I do not group it, FmDisplay will show multiple products with the same details due to the numbers of comments added to the corresponding product.

If I were to delete the linkage, the results is even worse!

Please help....

 

[neileg]

Yuk!

I don't understand:
1) Why you have applied grouping in your queries
2) Why you have nested forms
3) Why the forms are unbound with the datasource set in the OnLoad event
4) Why you have linked the Comments table in the query on which your main form is based (I think this is what is locking your data)

It's just all too complex for the simple application you have.

 

[Nishikawa]

Hi, Thanks for the questions

1)I do not want to use grouping, but if I don't; like the message before that, duplicate data will be displayed. That is the cause of the problem and why this thread is created.

2)Nested form is used because other information are also display within the same form. ( I have removed a lot of things in the scaled down database)

3) Using unbound form with datasource set in OnLoad event is to increase the performance of the database. (This is what I read in another site; my database is going to server over 20 users)

4) This is linked so that I am able to use similar record source.

Btw, this database is not as small as you seen. what is attached is less than 10% of the entire system that I'm creating.

 

[neileg]

1)I do not want to use grouping, but if I don't; like the message before that, duplicate data will be displayed. That is the cause of the problem and why this thread is created.

No, you have masked the problem, not solved it

2)Nested form is used because other information are also display within the same form. ( I have removed a lot of things in the scaled down database)

OK, I did wonder about that

3) Using unbound form with datasource set in OnLoad event is to increase the performance of the database. (This is what I read in another site; my database is going to server over 20 users)

Mmm, maybe.

4) This is linked so that I am able to use similar record source.

No, this is what is causing your duplicate records. You have linked the data in the forms, you don't need to do this in the query

Btw, this database is not as small as you seen. what is attached is less than 10% of the entire system that I'm creating.

I did get that impression.

If I get a chance I'll rework your sample, but I won't have time today.