Hi,
Thanks for the reply
I have the following tables which I am trying to write to.
Since the sequence I am running is going to be static, so no steps or subsequences are going to be called dynamically. To avoid duplication of the same step data multiple times, I would like to prepopulate the Steps table before actually running the sequence, which I believe I can do using the TestStand API and Labview. In the figure above you can see Steps linking with Steps_1, these are both the same table it is just how MS Access is showing the Parent-Child relationship, so we can have a step which may be a subsequence which could contain further steps.
What I want to do is during runtime when TestStand is storing test results to the database for it to link to the Steps table using the Step_ID.
Which is why I asked to use TestStand Variables / Properties (eg. Logging.StepResult.TS.Index) to query the Steps table with to get a value for this field. Since I have a Parent-Child relationship for steps, instead of using the Parent Results Result_ID as a ‘foreign key’ I would like to use it in a query to obtain its Step_ID which I can link to Parent_Step_ID in getting the Step_ID for the new result, which is why I had asked about how to query using Foreign Key.
Hope that helps understand what I am trying to do
Thanks
Kewal