How to ensure primary/foreign key match in two tables on insertion?

Asked Oct 21 '15 at 17:42

Active Oct 21 '15 at 17:42

Viewed 26 times

I have Order and OrderLine tables in my access database.

When I enter each OrderLine I would need to enter the matching OrderNo, but how when I don't know the OrderNo in a C# application?

For example I would insert the CustomerNo and OrderDate into the Order table and the OrderNo will be auto assigned. Now I want to insert each item into the OrderLine table but I don't know the OrderNo of that Order to sync it all together?

asked Oct 21 '15 at 17:42

user5467760

This is too vague, can you provide the table structure of the tables in question ? – Shashank Shekhar Oct 21 '15 at 17:44
I don't how in Access but in SQL you get the new ID via @identity. – paparazzo Oct 21 '15 at 17:46

How to ensure primary/foreign key match in two tables on insertion?

0 Answers0