andrej hupka - 2009-01-31 05:45:44
Hello
I have 4 tables.
1. Parts
this table content four fields
PartID (primary)
Reference (varchar)
Title (varchar)
PROJECTID (int)
2.Project
this table content two fields
PROJECTID (primary)
Title (varchar)
3. Entry
this table content two fields
PartID(int)
StockIn (int)
3. Sortie
this table content two fields
PartID(int)
StockOut (int)
Now I need join this tables like Table project with Table parts where Project.PROJECTID = parts.PROJECTID and Tables Parts,Entry and Sortie where Entry.PartId and Sortie.PartID=Parts.PartID
and StockIn and StockOut must be total
-------------------------------------------------------------------------
I try to do it and itīs OK, but like I use repeat region calculation does not work correctly.
Thanks for your help
