Nancy,
Unfortuntely this won't work. I have a main table called LOG that links to 3 other tables EMP, CLIENT, CODE to get a few fields of information. When I blow out the relationships, the entry form page with combos, works fine and they are alphabetized, yeah!! When I flip to page2 the grid, all the column textboxes that hold the info from the other files list the same right down the column even though its different.
The textboxes use control sources like:
TRIM(employee.lastname)+", "+employee.firstname
I thought about using a view (never tried one) but was prompted in the view wiz that it wouldn't work because I can't have the SAME main table (LOG).
Any other suggestions for the grid without losing the "link" feature for flipping back and forth for editing purposes between the two page frames.
Peter Brama
West Pointe Enterprises
VFP is getting easier but STILL alot to learn!!