Import to a combo box from a query

  • Thread starter Thread starter SorryTo Ask
  • Start date Start date
S

SorryTo Ask

Hi all,

On a form, I have a name combo box (Name1) and access names from a query. I
would like to also import with those names, their organization as listed in
the query and have that separately inputted into another field (Group) so
that Name1 corresponds to Group as listed in the query. Any ideas how to do
this?

Also how do I set all reports & forms to work with an A4 default page. The
Options only lists the margins.

Cheers

John
 
Dear John:

Could it be that all you need to do is add the Organization to the
query and add a column to the combo box? On the Click event of the
combo box, you could assign the value from the Organization column to
another control.

However, in every case I can think of, you'd be much better served to
NOT do this. If the Organization assigned to the Name is changed,
even in just how it is spelled, then copying it to another place in
the database just makes for a place where you must automatically
update every change, or face "corruption" of the data.

Frankly, this is just NOT DONE in good design. If there is an
assigned Organization for every Name, then this association should be
recorded in only one place in the database. You can always include
this equation between Name and Organization anywhere it is needed by
joining to the table where Name yields Organization every time you
need to want to see what Organization is currently assigned to any
Name.

Databases are very much meant to be used in this fashion. You'll be
awfully glad you follow this "rule" of design if you just begin using
it.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top