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
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