Re: How can I organize my database?

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 02/17/05 

Date: Thu, 17 Feb 2005 05:13:33 -0800

Giovanni

I'm not sure I understand what you are trying to do...

Are you asking how you can put multiple values into a single record's field
(perhaps something like "France; Germany; Italy; ..." in a single field)?
If so, please reconsider. This reflects a one-to-many relationship between
your record and the values you are trying to stuff into the single field --
in a relational database (Access), you don't want to do this.

While it is possible to do, it will only cause both you and Access
headaches, as you will need to build work-arounds to handle what Access
could easily manage if the data were more fully normalized.

Please explain a bit more about:

> have the
> chance to put more countries and more regions for each agency at the same
> time. 

-- 
More info, please ...
Jeff Boyce
<Access MVP>
"Giovanni" <Giovanni@discussions.microsoft.com> wrote in message
news:89E4C624-8A7B-426B-AD1B-D2A04B0975AC@microsoft.com...
> How will I be able to organize the database in order to put more than one
> value in one field (such as countries and regions)?
> The problem is that I need to organize the database in order to have  the
> chance to put more countries and more regions for each agency at the same
> time.
> Could you please help me?

Relevant Pages

  • How can I organize my database?
    ... How will I be able to organize the database in order to put more than one ... chance to put more countries and more regions for each agency at the same ...
    (microsoft.public.access.tablesdbdesign)
  • UN womens agency blocked by Cuba and anti-women Islamic countries
    ... But, as Steve Edwards reports below, the UN can't even bring itself to stand up to four countries that oppose creation of a super-agency to focus on promoting the rights of women. ... Sudan, Iran, Cuba and Egypt. ... A panel subsequently recommended that the work of four smaller UN women's agencies needed to be brought together under a bigger agency, and a budget of around $1 billion U.S. is envisioned for the new entity. ...
    (soc.culture.cuba)
  • Re: Basic application design
    ... simultaneously by users in all four countries. ... Database is in one country where the internet is excellent. ... If we go for an ASP net based solution, then the server hosting the ...
    (microsoft.public.dotnet.languages.vb)
  • Re: WHY
    ... as easily as you can put it in a spreadsheet? ... Rates are defined BETWEEN two countries. ... > countries to determine the respective exchange rate basis (and I hope ... > And this is something you can't directly translate to a database. ...
    (microsoft.public.excel)
  • Forms and Subforms - sharing info between text/combo boxes
    ... I've been banging my head against a few roadblocks in an Access 2000 database ... Tab2/level 2 subform with shipment info that has a combo ... box to access only those contacts associated with that agency. ... I want the subcategory box only to list those items associated ...
    (microsoft.public.access.forms)