star schema

[Joshua6007]

I have 3 tables then another table (loc_adjustment) that has joins all 3
tables.

id
value
x3

id
t1.id
t2.id
t3.id
value

How can I easily populate the third table. The first 3 tables are already
populated.
Thanks.

 

[Jeff Boyce]

General descriptions lead to general suggestions...

Use append queries.


--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/