Reply to thread

Message: [QUOTE="Lynn Trapp, post: 2563971"] If I understand you correctly, you need to create 2 tables (parent/child). ActivityTable ActivityID (PK) Date Country Dept ProcessTable ProcessID (PK) ActivityID (FK) Process_name Process_Owner Process_Date -- Lynn Trapp MS Access MVP [URL="http://www.ltcomputerdesigns.com"]www.ltcomputerdesigns.com[/URL] Access Security: [URL="http://www.ltcomputerdesigns.com/Security.htm"]www.ltcomputerdesigns.com/Security.htm[/URL] Jeff Conrad's Access Junkie List: [URL]http://home.bendbroadband.com/conradsystems/accessjunkie.html[/URL] [/QUOTE]