Best way to do this.

#1

The setup:
I have developed an anesthesia assessment form attached to our clinical
database. This form's data model has two tables in it. There are times when
these patients are repeat patients. I would like to be able to give the user
easy access to the previous assessments and even copy some of the data from
a previous encounter that the user will choose.
I don't want the current record to show up on the form showing the previous
records

The question:
Is it better to use setgenfilter and just filter for the patients medical
record number OR have the form run a query and copy all the previous
records to a new set of tables and have them view the records in a new form
and do what they need to do?

I think the first one is the most elegant but I don't see a way to do
setgenfilter and NOT have the current record also viewed.

Thanks,

Craig Futterman

#2

Quote:

I think the first one is the most elegant but I don't see a way to do
setgenfilter and NOT have the current record also viewed.

a second filter excluding the current date and/or current "visit number" ??

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

"Craig" <craig.futterman (AT) nospam (DOT) comcast.net> wrote

Quote:

The setup:
I have developed an anesthesia assessment form attached to our clinical
database. This form's data model has two tables in it. There are times
when these patients are repeat patients. I would like to be able to give
the user easy access to the previous assessments and even copy some of the
data from a previous encounter that the user will choose.
I don't want the current record to show up on the form showing the
previous records

The question:
Is it better to use setgenfilter and just filter for the patients medical
record number OR have the form run a query and copy all the previous
records to a new set of tables and have them view the records in a new
form and do what they need to do?

I think the first one is the most elegant but I don't see a way to do
setgenfilter and NOT have the current record also viewed.

Thanks,

Craig Futterman

#3

Quote:

I think the first one is the most elegant but I don't see a way to do
setgenfilter and NOT have the current record also viewed.

a second filter excluding the current date and/or current "visit number" ??

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

"Craig" <craig.futterman (AT) nospam (DOT) comcast.net> wrote

Quote:

The setup:
I have developed an anesthesia assessment form attached to our clinical
database. This form's data model has two tables in it. There are times
when these patients are repeat patients. I would like to be able to give
the user easy access to the previous assessments and even copy some of the
data from a previous encounter that the user will choose.
I don't want the current record to show up on the form showing the
previous records

The question:
Is it better to use setgenfilter and just filter for the patients medical
record number OR have the form run a query and copy all the previous
records to a new set of tables and have them view the records in a new
form and do what they need to do?

I think the first one is the most elegant but I don't see a way to do
setgenfilter and NOT have the current record also viewed.

Thanks,

Craig Futterman

#4

Quote:

I think the first one is the most elegant but I don't see a way to do
setgenfilter and NOT have the current record also viewed.

a second filter excluding the current date and/or current "visit number" ??

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

"Craig" <craig.futterman (AT) nospam (DOT) comcast.net> wrote

Quote:

The setup:
I have developed an anesthesia assessment form attached to our clinical
database. This form's data model has two tables in it. There are times
when these patients are repeat patients. I would like to be able to give
the user easy access to the previous assessments and even copy some of the
data from a previous encounter that the user will choose.
I don't want the current record to show up on the form showing the
previous records

The question:
Is it better to use setgenfilter and just filter for the patients medical
record number OR have the form run a query and copy all the previous
records to a new set of tables and have them view the records in a new
form and do what they need to do?

I think the first one is the most elegant but I don't see a way to do
setgenfilter and NOT have the current record also viewed.

Thanks,

Craig Futterman

#5

Quote:

I think the first one is the most elegant but I don't see a way to do
setgenfilter and NOT have the current record also viewed.

a second filter excluding the current date and/or current "visit number" ??

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

"Craig" <craig.futterman (AT) nospam (DOT) comcast.net> wrote

Quote:

The setup:
I have developed an anesthesia assessment form attached to our clinical
database. This form's data model has two tables in it. There are times
when these patients are repeat patients. I would like to be able to give
the user easy access to the previous assessments and even copy some of the
data from a previous encounter that the user will choose.
I don't want the current record to show up on the form showing the
previous records

The question:
Is it better to use setgenfilter and just filter for the patients medical
record number OR have the form run a query and copy all the previous
records to a new set of tables and have them view the records in a new
form and do what they need to do?

I think the first one is the most elegant but I don't see a way to do
setgenfilter and NOT have the current record also viewed.

Thanks,

Craig Futterman

#6

Quote:

I think the first one is the most elegant but I don't see a way to do
setgenfilter and NOT have the current record also viewed.

a second filter excluding the current date and/or current "visit number" ??

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

"Craig" <craig.futterman (AT) nospam (DOT) comcast.net> wrote

Quote:

The setup:
I have developed an anesthesia assessment form attached to our clinical
database. This form's data model has two tables in it. There are times
when these patients are repeat patients. I would like to be able to give
the user easy access to the previous assessments and even copy some of the
data from a previous encounter that the user will choose.
I don't want the current record to show up on the form showing the
previous records

The question:
Is it better to use setgenfilter and just filter for the patients medical
record number OR have the form run a query and copy all the previous
records to a new set of tables and have them view the records in a new
form and do what they need to do?

I think the first one is the most elegant but I don't see a way to do
setgenfilter and NOT have the current record also viewed.

Thanks,

Craig Futterman

#7

Quote:

I think the first one is the most elegant but I don't see a way to do
setgenfilter and NOT have the current record also viewed.

a second filter excluding the current date and/or current "visit number" ??

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

"Craig" <craig.futterman (AT) nospam (DOT) comcast.net> wrote

Quote:

The setup:
I have developed an anesthesia assessment form attached to our clinical
database. This form's data model has two tables in it. There are times
when these patients are repeat patients. I would like to be able to give
the user easy access to the previous assessments and even copy some of the
data from a previous encounter that the user will choose.
I don't want the current record to show up on the form showing the
previous records

The question:
Is it better to use setgenfilter and just filter for the patients medical
record number OR have the form run a query and copy all the previous
records to a new set of tables and have them view the records in a new
form and do what they need to do?

I think the first one is the most elegant but I don't see a way to do
setgenfilter and NOT have the current record also viewed.

Thanks,

Craig Futterman

#8

Quote:

I think the first one is the most elegant but I don't see a way to do
setgenfilter and NOT have the current record also viewed.

a second filter excluding the current date and/or current "visit number" ??

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

"Craig" <craig.futterman (AT) nospam (DOT) comcast.net> wrote

Quote:

The setup:
I have developed an anesthesia assessment form attached to our clinical
database. This form's data model has two tables in it. There are times
when these patients are repeat patients. I would like to be able to give
the user easy access to the previous assessments and even copy some of the
data from a previous encounter that the user will choose.
I don't want the current record to show up on the form showing the
previous records

The question:
Is it better to use setgenfilter and just filter for the patients medical
record number OR have the form run a query and copy all the previous
records to a new set of tables and have them view the records in a new
form and do what they need to do?

I think the first one is the most elegant but I don't see a way to do
setgenfilter and NOT have the current record also viewed.

Thanks,

Craig Futterman

#9

On Mon, 12 May 2008 11:48:08 -0400, "Craig"
<craig.futterman (AT) nospam (DOT) comcast.net> wrote:

Quote:

The setup:
I have developed an anesthesia assessment form attached to our clinical
database. This form's data model has two tables in it. There are times when
these patients are repeat patients. I would like to be able to give the user
easy access to the previous assessments and even copy some of the data from
a previous encounter that the user will choose.
I don't want the current record to show up on the form showing the previous
records

The question:
Is it better to use setgenfilter and just filter for the patients medical
record number OR have the form run a query and copy all the previous
records to a new set of tables and have them view the records in a new form
and do what they need to do?

I think the first one is the most elegant but I don't see a way to do
setgenfilter and NOT have the current record also viewed.

1. Create a new record.
2. Use SetRange (rather than SetGenFilter) to select the patient's
number.
3. If NRecord() > 0, use End() to go to the last (most recent) record
and copy the fields you want into the new record.

How's that?

Bill

----------------------------------------------------------------
Reverse parts of the user name and ISP name for my e-address

#10

On Mon, 12 May 2008 11:48:08 -0400, "Craig"
<craig.futterman (AT) nospam (DOT) comcast.net> wrote:

Quote:

The setup:
I have developed an anesthesia assessment form attached to our clinical
database. This form's data model has two tables in it. There are times when
these patients are repeat patients. I would like to be able to give the user
easy access to the previous assessments and even copy some of the data from
a previous encounter that the user will choose.
I don't want the current record to show up on the form showing the previous
records

The question:
Is it better to use setgenfilter and just filter for the patients medical
record number OR have the form run a query and copy all the previous
records to a new set of tables and have them view the records in a new form
and do what they need to do?

I think the first one is the most elegant but I don't see a way to do
setgenfilter and NOT have the current record also viewed.

1. Create a new record.
2. Use SetRange (rather than SetGenFilter) to select the patient's
number.
3. If NRecord() > 0, use End() to go to the last (most recent) record
and copy the fields you want into the new record.

How's that?

Bill

----------------------------------------------------------------
Reverse parts of the user name and ISP name for my e-address