Zydeceltico
Registered User.
- Local time
- Yesterday, 21:09
- Joined
- Dec 5, 2017
- Messages
- 843
Hi all -
I have two tables and three forms.
Forms 1 and 3 are bound to to Table 1. Form 2 is bound to Table 2 and related to Table 1 via ID on Table 1 and ID_FK on Table 2.
Right now I open Form 1; enter some data; click a button to open Form 2; enter some more data; click a save button on Form 2 and both Form 1 and Form close - saving to their respective tables.
I have a condition where I would open Form 1 (do stuff) then open Form 2 - and decide that I need to stop entering data on Form 2 and open Form 3 from Form 2 while Form 1 is still open (with it's autonumber ID still Dirty as Form 2 is modal) and use Form 3 to enter more data that I should have originally entered on Form 1 and which would be recorded on the same row as the record currently represented on Form 1 - - it is kind of an "append" I guess.
That is the ONE thing I have not yet tried to get this to work.
Anyone have any better solutions or ideas?
(I'm being cryptic trying to avoid writing a novel)
Thanks,
Tim
I have two tables and three forms.
Forms 1 and 3 are bound to to Table 1. Form 2 is bound to Table 2 and related to Table 1 via ID on Table 1 and ID_FK on Table 2.
Right now I open Form 1; enter some data; click a button to open Form 2; enter some more data; click a save button on Form 2 and both Form 1 and Form close - saving to their respective tables.
I have a condition where I would open Form 1 (do stuff) then open Form 2 - and decide that I need to stop entering data on Form 2 and open Form 3 from Form 2 while Form 1 is still open (with it's autonumber ID still Dirty as Form 2 is modal) and use Form 3 to enter more data that I should have originally entered on Form 1 and which would be recorded on the same row as the record currently represented on Form 1 - - it is kind of an "append" I guess.
That is the ONE thing I have not yet tried to get this to work.
Anyone have any better solutions or ideas?
(I'm being cryptic trying to avoid writing a novel)
Thanks,
Tim