General information
Category:
Forms & Form designer
Title:
Re: Cannot get the textbox to show the correct infomration
I created a formset that has two forms (form1 and form2) which uses 3 tables (table1, table2, and table3). The contents of the three tables are as follows.
Table1: member_name, member_id
Table2: member_id, chapter, begin_date, end_date, daily_id
Table3: daily_id, service_date, treatment, cost
Table1 has a one-to-many relationship with table2 (member_id) and table2 has a one-to-many relationship with table3 (daily_id). Form1 shows the daily record of the member, plus the member_name, member_id, and chapter from table1 and table2. I have no problem in showing those information. Form2 allows the user to add a daily record for a particular member. The user input the member's name and the date, and the program I wrote will append a record in table3, update the daily_id and service_date, release form2 and go back to form1. Here comes the problem. When I go back to form1, only the service_date is shown, and all other textboxes are shown in blank. However, when I move to another record and go back, all the text boxes are showing the correct information.
After updating daily_id and service_date, I have the following code.
thisform.enabled=.F.
thisform.visible=.F.
WITH thisformset.form1
.refresh()
.enabled=.T.
.activate
.show
ENDWITH
Can anyone show me how I can get the form show the updated information? (I am using optimistic table buffering.)
Chu
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only