Greetings all We have a problem w.r.t. relationships between tables giving incorrect lookups when compund keys exist. Table A with a compound PK of a,b,c is related to table B. So table B has an FK of a,b,c, and that's how the 2 tables relate. On table B's form, there is a grid that displays Table A. However, when we create a new record of A, none of the lookups work? Does anyone know why? (We know that the reason is that Table A's PK is incomplete while filling the fields in. How do we get around this problem?) Thanks
