Will, i still be able to get the value if all the tables are updated at the same time?
Let me try explaining it better. I have a table called tblMeet. It has a primary key called ID which is an autoNumber and a meetName field set to 'Wembley'. Then i have another table called tblEvent. It also has an pimary key ID field set as an autoNumber, it has a eventName field, as it has a field called Meet_ID which is the foriegn key to the ID field in my tblMeet. Now in my java program, i want to try and set this foriegn key. I have got a working query in my database, like so
CODE
INSERT INTO tblEvent ( Event_Name, Meet_ID )
SELECT '100M Run', [ID]
FROM tblMeet
WHERE Meet_Name='Wembley';
But now i need to do this in my java program.
This post has been edited by nick2price: 26 Sep, 2008 - 05:25 AM
| 