Indexing on an expression

[Samalia]

I have two tables that are linked upon a stocid, which in the child table is one field, and in the parent table it is 5 fields, account, nursery, seedlot, type and age.
When I navigate through a form that has the parent on top and the child in a grid it had no problem navigating through both tables. But when I try to search for a specific record in the child table the corresponding record is not found in the parent table. I've tried forcing it to find the correct stocid but it has not done so for me. Any help would be appreciated.

- Samalia

 

[JimWWinter]

Samalia,

How do you generate the index key for the parent table?

In any event, you'd probably find it easier to maintain if you used a single primary key for that table, preferably something like an autoincrementing integer.

Regards,
Jim

 

[Mike Lewis]

Samalia,

when I try to search for a specific record in the child table the corresponding record is not found in the parent table.

How are you doing the search?

In general, there's no reason why searching for a child record will move the record pointer in the parent record. You need to write code explicitly to do that.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[Samalia]

When searching for the stocid in the parent table I'm first searching for a different record in the child table, then I copy the child table's stocid to a variable cstocid and then search for that in the parent table. I've tried searching the index on the parent table and even searching all the fields together to match the cstocid variable but each time I get a no find.

- Samalia

 

[Mike Lewis]

Samalia,

When you copy the child's stocid to a variable, try wrapping it with an ALLTRIM(). That usually solves that particular problem.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk