masoud_sedighy
Registered User.
- Local time
- Yesterday, 17:17
- Joined
- Dec 10, 2011
- Messages
- 132
I have two tables. In table1 I have 2 columns like below, Doc No is (pk)
Doc No Title
-------- -----------
Doc-0001 test-0001
Doc-0002 test-0002
In table 2 I also have two columns Doc No (pk), Transmittal (pk)
Doc No Transmittal
--------------------------
Doc-0001 TT-0001
Doc-0001 TT-0002
Doc-0002 TT-1000
Now I want to create a continuous form that has 3 fields based on table 1 like below
Doc No title checkbox
if I have related record for each Doc No in table2 it shows in the continuous form with ticked check box, in the form and when un ticked check box it deleted related records table2.
I have thought about that with steps like below but I have some doubt:
1-I have to write a query based on table1 and it has a calculated column that returns (0) or (-1) if find related record in table 2.
Doc No title checkbox
2-I have to write a before update event for check box of the form for deleting related records in table 2 when untick the checkbox.
My question is about the calculated field in the form. Can I update that?
I mean can I untick that in the form? Or just it is a read only field and I cannot tick or untick that and so event procedure does not work on that?
how can handle this problem? is possible updating calculated field? for handling this scenario need changing design of tables or what is the best solution for solving this problem
What is the solution please?
Doc No Title
-------- -----------
Doc-0001 test-0001
Doc-0002 test-0002
In table 2 I also have two columns Doc No (pk), Transmittal (pk)
Doc No Transmittal
--------------------------
Doc-0001 TT-0001
Doc-0001 TT-0002
Doc-0002 TT-1000
Now I want to create a continuous form that has 3 fields based on table 1 like below
Doc No title checkbox
if I have related record for each Doc No in table2 it shows in the continuous form with ticked check box, in the form and when un ticked check box it deleted related records table2.
I have thought about that with steps like below but I have some doubt:
1-I have to write a query based on table1 and it has a calculated column that returns (0) or (-1) if find related record in table 2.
Doc No title checkbox
2-I have to write a before update event for check box of the form for deleting related records in table 2 when untick the checkbox.
My question is about the calculated field in the form. Can I update that?
I mean can I untick that in the form? Or just it is a read only field and I cannot tick or untick that and so event procedure does not work on that?
how can handle this problem? is possible updating calculated field? for handling this scenario need changing design of tables or what is the best solution for solving this problem
What is the solution please?