Thread

I have some data that I would normally put in to a DB and write a simple web application to search it.  However, I’m wondering if I can efficiently use EE to do the following.

Here is the very simple data model:

In the state of Wisconsin, there are 300 school districts.

Serving these school districts are 8 field representatives, each handling a subset of those districts.

I need:

-A simple search with a drop-down for school districts that returns a result showing the entry for that district’s field representative.

-A way for a user to easily add, delete, modify school districts and their relationship to field representatives.  Ideally, one could edit 50 districts at once, and reassign them to a field rep with one click.  Or, take 25 school districts that area assigned to representative A and switch them to representative B.  What I want to avoid is the need for the user to manually edit each school district and reassign it to a representative.  This reassignment needs to be possible en masse.

Is this something I can do relatively easily in EE?  I’ve worked with EE on several projects, and I can hack around in PHP if needed.

Thanks,

Ben

I think you might have to take a look at related entries.

e-man:

That could work great.  However, is there any way to assign these related entries en masse, that is, can I choose ten school districts, edit selected, and reassign their related entry?

Before you posted I tried making one custom status field for the “school districts” weblog with values representing the names of field reps.  Then I can do edit selected on a whole bunch at once.

I think that method will work ok, but I’m wondering then how I can take the results of a form field (the school district name or ID), and pull up the name of the status that corresponds to it. And then I would pull a weblog entry with the same name as the status to display details about the field rep.