append one to many

J

JohnLute

I have two tables:
tblSUsULs
(PK)autonumULID
(PK)txtProfileID

tblULsLayers:
(PK)numULID
(PK)txtProfileID

Previously, tblULsLayers was related to tblProfiles in a one-to-many
relationship, however, this has to be terminated and now I've got to expand
the db with the new tblULsLayers which needs to relate as many to one with
tblSUsULs.

tblULsLayers needs the numULID field appended with all the records from
tblSUsULs, however, tblULsLayers has many records from the previous
relationship.

I'm very confused. How can I append this?

Any help would be greatly appreciated!
 
Top