aaronward
Board Regular
- Joined
- Aug 2, 2006
- Messages
- 165
Here is my (condensed) table format:
Table: A
ID|EmpNum|AuditDate|Score
Table: B
A_ID|Item1|Item2|Item3|Item4
I am essentailly storing details of employee audits on their work. I have my first table (table A) storing the Basic information about the audit. Table B will store the individually scored item results: items 1-4. Table A has an autoincrement unique id created by access. I reference the items in table B by table A's ID. I am at a standstill upon entering the audit data, tho. I currently use two seperate sql transaction for entry; Entering Table A's data then table B's data. However, I havent a way to reference Table A's ID after entry in order to use it for table B. Any suggestions on the best method of completing this task? Thanks!
Table: A
ID|EmpNum|AuditDate|Score
Table: B
A_ID|Item1|Item2|Item3|Item4
I am essentailly storing details of employee audits on their work. I have my first table (table A) storing the Basic information about the audit. Table B will store the individually scored item results: items 1-4. Table A has an autoincrement unique id created by access. I reference the items in table B by table A's ID. I am at a standstill upon entering the audit data, tho. I currently use two seperate sql transaction for entry; Entering Table A's data then table B's data. However, I havent a way to reference Table A's ID after entry in order to use it for table B. Any suggestions on the best method of completing this task? Thanks!