[AccessD] combo from multiple sources

I'm originally from Lafayette, LA...and last month a good friend called for 
a favor, for her friend, who happened to be a cop.  The favor was Access 
Related(go figure)...so I looked at the db she was working on.  She had done 
well with how the form looked and had most of the fields needed in some 
table somewhere...but 1 PK for all the tables...and it didn't play well with 
itself.

After hearing how they got to this point(here's a little history):  This is 
to track arrests, drugs, and weapons.  Right now they write it down in a 
notebook...and then go through the book and count the points of interest to 
report up.  They have no budget...so she was trying to build it herself.  
The officers take up a collection each week to have their 'Port-O-Jon" 
emptied.

This kinda ticked me off.  I mean how long has it been...and the cops have 
to pay for their own toilet?  What other service is local government 
supposed to be providing, but can't because of lack of equipment/software?  
How does social services know they need to go check on little mary or bobby 
to make sure their getting fed???


Anyway, they just wanted a little 'shove' in the right direction with the 
db...but it seemed more like pushing them off a cliff...so I built the data 
model, all of the forms, and the logic needed to get the reports at the 
end...and some reports...but I left the db open for her to change the 
labels, colors, whatever...and to write additional queries as needed.

I couldn't charge them.  OK>>>Stepping down from podium<<<<<

Sorry about the rant...

At one point I wanted to show every name associated with a case in a combo 
to identify which name was used.  This included alias's which were in a 
different table.  So I needed data displayed from 2 different tables...and I 
just used a UNION query as the source.

Does this address your question?

Thanks,

Mark A. Matte




>From: "Susan Harkins" <ssharkins at setel.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] combo from multiple sources
>Date: Mon, 19 Feb 2007 17:15:49 -0500
>
>
>I recently built, and donated, a db for the New Orleans Police department.
>One aspect was suspect info.  I had to create another section to accomodate
>multiple aliases.  I could have used a combo to list names from both
>tables...I ended up using a more detailed form to search...but a combo to
>list names and aliases could have been used...I would have just used a 
>UNION
>
>query as the source.
>
>===========Donated? You're a good guy. Bill spent a few weeks down there
>right after Katrina and he promised a few of the cops that we'd come back
>for a vacation and spend money. ;)
>
>So, if you created such a combo, what would you use it for?
>
>Susan H.
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Find a local pizza place, movie theater, and more….then map the best route! 
http://maps.live.com/?icid=hmtag1&FORM=MGAC01