I have 2 separate databases. Each has a table that is related one-to-many.

Example:

Table1: (with 1 record)
ID = 100
Qty = Sum(Table2::total)

Table2: (with 2 records)
ID = 100
total = 5

ID = 100
total =5

Thus, the field "Qty" in Table1 should calculate to = 10.

I have that relationship working well, no problem there. However, the problem comes in when I want to display the field "Qty" from Table1 in Lasso:

[Inline: -Search, -Database='database1', -Table='Table1', -op='eq', 'id'='100'] [Records]
[Field:'Qty']
[/Records][/Inline]

Lasso returns to me a null value even though FileMaker clearly sees the relationship and properly calculates the information. The crazy thing is that I have other tables in my 2 databases where this isn't a problem and Lasso returns the information properly. I don't know what I'm missing here? Anyone have any thoughts.

--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/