Guest_imported
New member
- Jan 1, 1970
- 0
In creating link tables to an Oracle Database, How can one preserve the dependencies/relationships?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Linking to an Oracle Database
- Thread starter Guest_imported
- Start date
- Status
I would use a SQL statement in stead of other methods.
paste your code here and maybe we can help you with the syntax.
Like so
SELECT [Universal1].[On-LinePOs].[CUSTOMER],
[Universal1].[On-LinePOs].[ORDERID],
[Universal1].[CUSTOMERS].[CUSTOMER],
[Universal1].[CUSTOMERS].[CUSTNAME]
FROM [Universal1].[On-LinePOs] INNER JOIN
[Universal1].[CUSTOMERS] ON
[Universal1].[On-LinePOs].[customer] = [Universal1].[CUSTOMERS].[CUSTOMER]
this example shows 2 tables that have the CUSTOMER column in common.
Table 1 is the "Customers" table and table 2 is the "On Line POs"
DougP, MCP
dposton@universal1.com
Ask me how Bar-codes can help you be more productive.
paste your code here and maybe we can help you with the syntax.
Like so
SELECT [Universal1].[On-LinePOs].[CUSTOMER],
[Universal1].[On-LinePOs].[ORDERID],
[Universal1].[CUSTOMERS].[CUSTOMER],
[Universal1].[CUSTOMERS].[CUSTNAME]
FROM [Universal1].[On-LinePOs] INNER JOIN
[Universal1].[CUSTOMERS] ON
[Universal1].[On-LinePOs].[customer] = [Universal1].[CUSTOMERS].[CUSTOMER]
this example shows 2 tables that have the CUSTOMER column in common.
Table 1 is the "Customers" table and table 2 is the "On Line POs"
DougP, MCP
dposton@universal1.com
Ask me how Bar-codes can help you be more productive.
- Status
Similar threads
- Locked
- Question
- Locked
- Question