Foreign Keys in Aware 7.1

rbross

Hello,

I need to access tables from an external MS_SQL DB. I have created the BO's pointing to the External tables and Aware did recognize the foreign keys and add the relationships, BUT their is no parent child connections actually made?
If I create a form of the Parent and add a tab to show the child records it does not display any records.
The field that links the two tables together is DocumentID.
Shortcut are allowed to be added so I add a shortcut and included it in the query for the child BO but still nothing displays in the query?

I also went through the steps of not accepting the foreign key in the child table and adding it manually but this does not seem to work either?
Has any one been able to get this to work correctly?

Jaymer

roger
i don't think that should be a problem.
when i started doing my MSSQL implementation, I wasn't letting Aware know about the relationships.
If I was on a header record, to show lines it was just a query with OrdLine.OrderNum = OrdHdr.OrderNum
and it worked fine.

Note: I later used fields in the legacy Btrieve system to calculate/generate RIDs (unique row ids) and then, having made the relationship in Aware, I populated the necc. fields so Aware would "know" about the relationship. I had to do this BEFORE importing data into Aware because I wanted to use native SQL import tools - if Aware was importing the data (much slower), then I wouldn't have needed to do any of this... just wait longer. This has nothing to do with your original Q though, suffice to say I used to have all my tables related to each other just fine "outside" of Aware's knowledge.