Doug

Here is the relationship:

Client Table (Fox4Dos table - for your info)
Allocation Table (VFP Table)

Client.Cl_Ref => Allocation.Cl_Ref

This is a one-to-many relationship, and I'm sure it's setup OK.

Kev