I tried to explain this before and i didn't do such a great job so after a little more investigation I’ll have another stab at it:
3 forms A, B, and C
derived from 3 tables tbl A, tbl B, and tbl C.
tbl A : 1 <--> many : tbl B :1< --> many : many tbl C
Frm C embedded in Frm B embedded in Frm A
Ok so far?
Problem: Unable to enter(or display) multiple values of B for A.
It will however allow this when I debug nut not when I run normally. I've tried creating a new front end but with no avail. I'm coming around to the idea that the problem therefore is not my code or layout but a access 97 problem. Any agree/disagree is anyone aware of this problem. As a tip off it's possible that this BD was originally written in Access 2000
All help appreciated
- Elfman
3 forms A, B, and C
derived from 3 tables tbl A, tbl B, and tbl C.
tbl A : 1 <--> many : tbl B :1< --> many : many tbl C
Frm C embedded in Frm B embedded in Frm A
Ok so far?
Problem: Unable to enter(or display) multiple values of B for A.
It will however allow this when I debug nut not when I run normally. I've tried creating a new front end but with no avail. I'm coming around to the idea that the problem therefore is not my code or layout but a access 97 problem. Any agree/disagree is anyone aware of this problem. As a tip off it's possible that this BD was originally written in Access 2000
All help appreciated
- Elfman