G
Guest
Hi everyone - great group and hope you can help with this.
I will try to ask this as clearly as possible. I have set up a database
holding records about when a client receives therapy (OT or PT) and the
duration of the therapy. The forms are received from several different
offices, but some of the offices also send logs of 'open' clients; ie the
therapy has started but not ended. Sometimes the 'open' logs come after the
main form! As we report on both open and closed records we must know if the
client is alreay on and adust accordingly. Just to add spice to this, there
are 5 data entry modules and 1 main database. Each module holds it own data
which is then sennt to a TEMP file in the main module. The data is scanned
for problems before uploading to the main database. The forms, both open and
closed are hand written so not always clear. To see if a client is alreay on
I have set up several subforms in the data entry modules which search - the
main database by exact name ; by first initial of first name + surname and by
DOB ; the TEMP file by first inital + surname and the entry file in the data
entry module by first initial + surname. As you can imagine it looks very
klugy on screen and means the user needs to read through several subforms to
look for a match.
Does anyone have an idea of how to compress this in any way!!
Thanks for any ideas
Dika
Kernow Girl
I will try to ask this as clearly as possible. I have set up a database
holding records about when a client receives therapy (OT or PT) and the
duration of the therapy. The forms are received from several different
offices, but some of the offices also send logs of 'open' clients; ie the
therapy has started but not ended. Sometimes the 'open' logs come after the
main form! As we report on both open and closed records we must know if the
client is alreay on and adust accordingly. Just to add spice to this, there
are 5 data entry modules and 1 main database. Each module holds it own data
which is then sennt to a TEMP file in the main module. The data is scanned
for problems before uploading to the main database. The forms, both open and
closed are hand written so not always clear. To see if a client is alreay on
I have set up several subforms in the data entry modules which search - the
main database by exact name ; by first initial of first name + surname and by
DOB ; the TEMP file by first inital + surname and the entry file in the data
entry module by first initial + surname. As you can imagine it looks very
klugy on screen and means the user needs to read through several subforms to
look for a match.
Does anyone have an idea of how to compress this in any way!!
Thanks for any ideas
Dika
Kernow Girl