markjde
Active Member
I have a table that contains current order header records and another table
that contains order header history records. What I am attempting to do is
create a business view that is essentially a union of both tables.
Then within a find/browse form use this business view to access the order
header records regardless of if they are current or historical records.
This is similar to V42119B which combines both current and historical sales
tables into a single business view.
The problem is that I am not able to select records from the second table to
create the business view. I have check out the V42119B and I can't even
select fields from the second table to modify this business view (not that I
want to do this, but just as a test).
Any ideas how I can create a similar business view to V42119B so that I can
create one myself for my application.
Thanks.
Mark
[email protected]
B7332 SP11, Intel NT4, SQL 7.0
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
that contains order header history records. What I am attempting to do is
create a business view that is essentially a union of both tables.
Then within a find/browse form use this business view to access the order
header records regardless of if they are current or historical records.
This is similar to V42119B which combines both current and historical sales
tables into a single business view.
The problem is that I am not able to select records from the second table to
create the business view. I have check out the V42119B and I can't even
select fields from the second table to modify this business view (not that I
want to do this, but just as a test).
Any ideas how I can create a similar business view to V42119B so that I can
create one myself for my application.
Thanks.
Mark
[email protected]
B7332 SP11, Intel NT4, SQL 7.0
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.