Posted: 3/24/2014 9:09:26 AM EDT
|
I have a database with several tables. The data will be added by importing an XML file.
In the main table, I have a primary key. It is an "auto number"... What I need is for this primary key number to populate out to the other tables as a foreign key. I created the cascading update and cascading delete with data integrity relationship for all of this... Except the actual number does not show up in the foreign key boxes automatically. The values are there as options on the foreign key combo box, but not automatically pushed. Is there a way I can force this value to automatically show, without having to go back and select it from the combo box?? |
|
Quoted:
Nooooooooo idea. Thanks anyway :) Been beating my head about this for a while... Basically, we have thousands of documents that are going to get imported via XML, and I am trying to save the admins from having to go and select from the combo box for each row. If I figure it out I shall report back! |
|
Quoted: Thanks anyway :) Been beating my head about this for a while... Basically, we have thousands of documents that are going to get imported via XML, and I am trying to save the admins from having to go and select from the combo box for each row. If I figure it out I shall report back! Quoted: Quoted: Nooooooooo idea. Thanks anyway :) Been beating my head about this for a while... Basically, we have thousands of documents that are going to get imported via XML, and I am trying to save the admins from having to go and select from the combo box for each row. If I figure it out I shall report back! |
|
Quoted:
It seems to me like this sort of thing would be better handled by SQL Server. Quoted:
Quoted:
Quoted:
Nooooooooo idea. Thanks anyway :) Been beating my head about this for a while... Basically, we have thousands of documents that are going to get imported via XML, and I am trying to save the admins from having to go and select from the combo box for each row. If I figure it out I shall report back! True story. I could do it on there. But, I have my instructions, and such as they are I shall try to fulfill them. |