A bit of newbie abvice please...!

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
 
D

Douglas J. Steele

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top