At 06:29 PM 2/20/2005, Dick Fey wrote:
A. If there are other common columns in the tables, does the data have to match?
Yes!
That's the rule of R:BASE matching apples to apples.
B. Does it matter if the common columns other than Refnum are included in the grid or not?
No.
Matching is done at the table/column level, not what you show in the form/grid.
C. Is there some way you have to tie them together? as you tie a view together
Yes.
Either RENAME other (non-matching) columns or base your form on a VIEW with ALIAS names for non-matching columns
Its a great idea, but no luck so far at making it work.
Normalize your database!
Very Best R:egards,
Razzak.
