A bit of newbie abvice please...!

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

Hi everyone,

I have a table set up in Access 2000, called "Business
names":

ID Name of Business Group1 Group2 Group3
AutoNum Text String Yes/No Yes/No Yes/No


Basically I want another table created and automatically
filled with records, based on the yes/no replies in the
1st table.

So, if the "Name of Business" field value is "Microsoft"
for example, and groups 1 and 3 are "yes", I want 2
records to be created in the new table: "Microsoft Group1"
and "Microsoft Group2" etc.

Is this possible? Thanks!

Martin
 
It might be possible, but it's certainly not recommended.

The Business names table isn't normalized: having Group1, Group2, Group3 is
what's referred to as a repeating group. Realistically, you should have 2
tables: one containing the ID and Name, and the second containing one row
for each group to which the business belongs.

If you want to work with your existing table structure, though, you don't
need new tables Microsoft Group1 and Microsoft Group2. There's never any
reason to have duplicated data. Instead, create queries Microsoft Group1
(which would be based on Business names WHERE Group1 IS TRUE), Microsoft
Group2 (WHERE Group2 IS TRUE) and so on. Use the queries wherever you would
otherwise have used the tables.
 
Back
Top