Solved Data Entry Form W/Subform Creates extra records?

[danbl]

This leads me back to one of my earlier questions. Does this mean that the larger Perioperative table should be divided into separate Preop, Interop, and Postop tables with vid as the foreign key in each?

 

[June7]

That was one of the options suggested in order to maintain 3 subforms without complicated VBA.

 

[danbl]

Okay ..... will get this done and give it a try. I am sure I will be back with additional questions many thanks

 

[June7]

You created the 3 tables in latest version. Just change the RecordSource of 3 subforms to reference tables.

 

[danbl]

Changes made ...... still creates two records for the Preop, Interop, and postop...

 

[June7]

Do you mean three records?

I am not understanding issue. Each table has 1 record for each visit. This is how it should be with your structure.

The Indicator fields are not needed but if you do want to retain, then use a DefaultValue and Lock checkbox so user can't change or even better, don't have viewable on form.

Why is there no patient ID in t_Visit? There is only a DOB for patient info. This cannot reliably retrieve records for specific patient.

 

[danbl]

If I enter data using the form(s), when you go to the individual tables (preop, interop, postop) there will be two entries for one record entered??

I get what you are saying for the default value ... just didn't do that at this point.
I opened the file I sent you and "vid" is the primary key in the table visits ?? and is the foreign key in the other tables.

 

[June7]

I tested data entry. I get a new record in t_Visit and a new record in each related table. This is what I would expect. What else are you seeing?

 

[danbl]

I am TOTALLY, TOTALLY confused!!!!

When I tested this before sending it to you, I got a duplicate in the tables I mentioned. When I opened it this morning after seeing your reply, I tried it again and as you said I got only one record in each table.

Any thoughts on how or why???

 

[June7]

No idea at all.

 

[danbl]

It seems that the data entry is working. However I have updated the interop form (frminterOpA) from the original form. When I added it to the data entry form it is not visible on the interop tab. When I added it to the form (frmVisitE) it is visible. How do I fix this???

 

[June7]

Form not showing is not primary issue. This is wrong from for Interoperative tab.

Why are you using a query with 3 tables as RecordSource? None of the tables are t_InteroperativeData. Why does Interoperative show PeroperativeIndicator?

Should that be Preoperative? Also Perop Comments should be Preop Comments?

Advise to remove spaces from naming convention.

 

[danbl]

I will post new thread for the form not showing issue.

Why are you using a query with 3 tables as RecordSource? I thought this had been fixed from a previous thread, done now, all the tab forms relate to the appropriate forms for data entry. frmVisitE is associated with with a query as it is used to correct or update data entry errors.

None of the tables are t_InteroperativeData. I am attaching the current version I am using and this table is present in the tables list.

Why does Interoperative show PeroperativeIndicator? Not sure where you saw this but in the attached version it is Interoperative indicator??

There are some spelling corrections that need to be made and the space issue in fieldnames has been pointed out. In future db's I will remember this. There are also some form field updates to be fixed as a result of splitting the one large table into 3 smaller ones.

 

[June7]

In earlier version, subform used is frmInterOpA. This form is bound to t_Postoperative Data and shows Peroperative Indicator.

This latest version now uses frmInterOp as subform and it does show.

Is there still an issue that needs to be addressed?

 

[danbl]

As far as the data entry goes, I believe this is now working as it should.
THANK YOU VERY MUCH FOR ALL YOUR ASSISTANCE!!!
Many things have been learned in this process .... I will post the other issue as a new thread and hopefully will get this resolved.

Thanks again.