N
Nick Mirro
About weekly, I have to toggle between 1:1 and 1:many between 2 tables to
keep form query updateable. The relationship is between patient visits and
billing ids. They are always 1:1 as there is only ever one bill generated
per visit.
I don't care if the relationship is 1:many but it won't seem to hold.
Periodically, the form that used the query becomes not updateable, and I
notice that the add record button in the query "datasheet view" becomes
dimmed out. So I toggle the relationship for a temporary fix.
What might I try to resolve this?
Nick
keep form query updateable. The relationship is between patient visits and
billing ids. They are always 1:1 as there is only ever one bill generated
per visit.
I don't care if the relationship is 1:many but it won't seem to hold.
Periodically, the form that used the query becomes not updateable, and I
notice that the add record button in the query "datasheet view" becomes
dimmed out. So I toggle the relationship for a temporary fix.
What might I try to resolve this?
Nick