General information
Category:
Coding, syntax & commands
>>I have a parent table P2 and two related child tables C1 and C2.
>>Each table has in excess of 1 million records. After SETting
>>the RELATIONs, how can I examine only those records in the
>>children tables that should be constrained to the parent relationship?
>>
>>Based on the child related info, I will update a field in the
>>parent table.
>Create a form with 3 grids. Set recordsources as P2, C1 and C2. In C* set linkmaster, childorder, relationalexpression. You're done.
>Cetin
I do not want to use a gird or any type of interface. The relations
have been set - no problem there. As I SCAN each parent record I want
to examine just the results of the children records and based on that
info update a field in the parent. For example, how do I know the
total number of records in child table one (C1)? How can I run a
query or a simple COUNT in the child that is constrained to the
matching parent record? A simple SUM was going through ALL records
in the child.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only