KComfort16
New member
- Local time
- Today, 16:03
- Joined
- Apr 3, 2020
- Messages
- 6
Is there a way to Concatenate Fields Automatically as the needed Fields are completed - Without a Query?
Situation
Table - ID ONLY
Columns - PartID, MoldID, PressID, RecordID
RecordID = [PartID]&"-"&[MoldID]&"."&[PressID] - this is my Unique Valve used with other Append Queries.
Unique Valve because PartID and MoldID can be Associated with MANY PressID - and when I run the Append Queries using RecordID as a Unique Valve Limits the Duplication of Records.
Situation
Table - ID ONLY
Columns - PartID, MoldID, PressID, RecordID
RecordID = [PartID]&"-"&[MoldID]&"."&[PressID] - this is my Unique Valve used with other Append Queries.
Unique Valve because PartID and MoldID can be Associated with MANY PressID - and when I run the Append Queries using RecordID as a Unique Valve Limits the Duplication of Records.