Linking Tables using ROWID

[EdAROC]

I'm working on a report and need to compile data from various tables of a commercial ERP database (I can't modify the database). The primary source table in this report is ORD_MACH_OPS, operations on shop floor for an order, and multiple fields uniquely identify a record, JOB_NO and MACH_SEQ_NO. When I compile the data, a lot of information for the report is the result of IIf's and calculations using data from a variety of tables. When I get to the final query, which the report uses, that preliminary query will need to be referenced again and linked to ORD_MACH_OPS.

Question: Can I store ROWID in ORD_MACH_OPS in the preliminary query and link by that value in the final query? In other words - I need to better understand the ROWID value. Does ROWID remain fixed "for life"? If not, will ROWID remain intact during the time it takes for the report to run? We use MS SQL Server and run database optimization periodically.

 

[dhookom]

We don't know if ROWID is a calculated expression or field. If it is a field, we don't know if it is re-calc'd or in a temp table or whatever.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[EdAROC]

Hmmm. I assumed ROWID was the value of an "internal value" and the ERP vendors were "passing it along" in the database tables definitions.

Your reply has helped - Looks like my next step is to ask the ERP vendors.

Thanks! You have been helpful - you have educated me.