Filter On a Recordset

  • Thread starter Thread starter darb
  • Start date Start date
D

darb

Thanks for taking the time to read my question.

I have 3 recordsets I am working with. The first one has
Service Personell names. The second is a list of the
farms they deal with filtered by the current record of
the first recordset. My problem begins when I want to
filter the third recordset, a table of transactions per
farm for all farms on the system, based on all the farms
that have been filtered out in the second recordset. I
could build a string to use as a filter, but I will need
more than 255 characters, as there are many farms per
service person. How do I filter one recordset based on
another recordset?

Thanks again for the help.

Darb
 
My problem begins when I want to
filter the third recordset, a table of transactions per
farm for all farms on the system, based on all the farms
that have been filtered out in the second recordset.
Click to expand...

I do not really understand the setup, but this is beginning to sound like a
straightforward join.
I
could build a string to use as a filter, but I will need
more than 255 characters, as there are many farms per
service person.
Click to expand...

I don't recognise any limitation in the database engine to strings of 255
chars; you may be force some UI objects to do your work rather than than
the actual database, which is designed for it.

If you could post some more details of what you are trying to achieve, we
may be able to point you in a more profitable direction.

B Wishes


Tim F
 
-----Original Message-----


I do not really understand the setup, but this is beginning to sound like a
straightforward join.


I don't recognise any limitation in the database engine to strings of 255
chars; you may be force some UI objects to do your work rather than than
the actual database, which is designed for it.

If you could post some more details of what you are trying to achieve, we
may be able to point you in a more profitable direction.

B Wishes


Tim F

.
Well, I'm not sure what to say.... You are right. I am
Click to expand...
not sure why I did not think of that. It's so obveous!

Thanks so much for the help! Have a great Christmas.

Darb
 
Back
Top