Multiple entries from 1 table to another table in 1 field?

H

Harmannus

Hallo,

How can i add multiple rows in a table to another table in 1 field?

eg.
table1
ColorID
DesignerID
Color

table2
DesignerID
Color

So i want the multiple color entries for a designer in table1 shown in 1
field in table 2: eg. red, blue, orange, black, white etc.

I want this code executed after every addition to table1 (so table2 is alway
up to date).

Thanx for any tips!

Regards,
Harmannus
 

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

Similar Threads

Help needed passing data from the form to a table. 0
delete records in one table that occur in another table 0
Combine data from multiple tables into combo box 3
Query on two tables with matching null fields 4
One-to-One Table keys 9
Data entry for a table from a form 1
Multiple IDs for same Employee 5
Update a field from 1 through 10 6

Top