Find especific data in a table

[mmonsalveg]

hi ...im trying to make an order reception app ... but im having problems with reports ... my question is .. if i have a table with a "reference" column wich i select all the reference my client order .. how i find and especific reference from all the orders and how many quantities from that reference ... example ..

Ref: 2020 you sell 500 units

i hope somebody can help me with that...

thank you in advance

[Søren Dyhr]

The relational structure usually facilitate this, and in this case might a many to many be the answer - if you hadn't put you question out so terse. So regard this as a stab in the dark... you might be needing something in this direction:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000717

--sd