[Solved] Numerical field-Subform link

[PMarcotte]

Hi everyone,

I inserted a numerical field in a form to show the total for a given invoice, but the field does not follow the form, I have to click inside it and then navigate the invoices (F_Facture, SommeFacture). I tried to copy the methods and SQL instructions but i'm obiously missing something.

On a very related note, sometimes I want to just show info in a dropdown ListBox, but the input gets repeated to the table with a new ID. What am I doing wrong?

I feel totally incompetent, and I'm usually a pretty smart guy.

Finally, I don't think I thanked eremmel for the last time he helped me, so a big thank you to him!

Cheers

[Villeroy]

Data properties of listbox:
Data Field = empty
Bound Field = empty

[UnklDonald418]

To get your total calculation on the form document F_Facture to follow the invoice you need to move the subform “Formulaire 1” to be a subform of ”SousFormDétail”.
The query supplying data to “Formulaire 1” should be changed to

Code: Select all

SELECT SUM( "TFD"."Qte" * "TB"."Prix" ) AS "SommeFacture", "TFD"."ID_Facture" FROM "T_FactureDetail" AS "TFD", "T_Facture" AS "TF", "T_Bijou" AS "TB" WHERE "TFD"."ID_Facture" = "TF"."ID" AND "TB"."ID" = "TFD"."ID_Bijou" GROUP BY "TFD"."ID_Facture";

And finally set both the Link Master fields and Link Slave fields properties to “ID_Facture”

[PMarcotte]

All right, now I understand how it works. If I want to show an aggregate of a table, or any content of a form, I need to insert a SubForm within that form and reference it in my ListBox (or TextBox, Currency, etc.)

Thank you very much. Every new thing is a small victory.