link Child/Master fields with Separate subform

[Enric]

I have a problem with a form in a database that i have open.
The form is called "Specifiche" and inside there are two subform: "SSpecifiche" and "SSDatiSpecifiche".

The subform "SSpecifiche" is connected to the table "Dati_Capitolati" while "SSDatiSpecifiche" is connected to the table "Codice_Specifica". These two tables have two fields in relation: "Codice specifica" with "Codice specifica" and "Nome Tabella" with "Tabella".

In fact, opening with an Access 97 I have no problems, but in 2010 the right table is empty, it does not load any field. Using the wizard fields do not help me to solve this problem. Documenting i read that maybe i need to create a query, but I can not understand the proceedings. For me the error is here:

LinkChildFields Master: Codice Specifica;[Nome Tabella]LinkChildFields: Codice Specifica;Tabella


If it helps I can post the database, because I realize that maybe the explanation is not beautiful.

I hope I was clear, I thank you for any help

[June7]

You appear to be using an image post service that attaches other images to your file, some offensive. I have deleted both images.

But I looked at your form images and cannot determine what cause of issue is. If you want to provide db, follow instructions at bottom of my post.

[Enric]

I apologize, I use adblock and i have not seen.

Picture number 1


Picture number 2

[June7]

Tables have circular relationships which could be causing issues. Review http://www.codeproject.com/Articles/...atabase-Design

Also review thread discussing table relationships https://www.accessforums.net/databas...ips-33735.html

I will try to take a closer look at your database this weekend. The language barrier is too much to deal with now.

[Enric]

For the moment, thank you very much. Is a long time that i can not solve this problem, I also asked about an Italian forum but have not found the solution.

[June7]

Sorry, cannot get past the language barrier to figure out the db. If you want to describe the nature of db and the data structure with English translation, will try to analyze. It's only 4 tables with few fields, could itemize in post narrative. I will say that is the oddest Relationships diagram I've ever seen.