Foreign Key In Existing DB

CalD

Hi Everyone,

I see now with 7.1 if we have a foreign key then aware can pick that up and create a relationship based on it to enhance the awareability with external tables... this is awesome but I am having trouble getting it to work.
Scenario,

Simple 1 to N relationship, invoice header and invoice lines.
Create a F key in invoice lines to invoice header
bring the tables into aware it appears to be OK, aware consolidates the F Key fields into a reference field, I can go into the invoice lines table and set the relationship to create a new one in the invoice header as well, and this appears to work. But when I switch it to testing mode I get this message :

"exception changing status of the busines space version Aware IM server encountered the following error .Column name corresponding to attribute name IBInvoices was not found"

IBInvoices is the name of the relationship reference in the invoice lines that aware generated from the F key...

any ideas what I am doing wrong here?

Many thanks

BenHayat

I've got this error message even with Aware's DB when I had changed an attribute name and could not get around this error. I had to put the original name back in, save it, then delete it, save it, then create a new attribute for this error to go away. Basically Aware's keeping track of attributes becomes out of sync with the actual db meta data and we have no tools to reset it.

CalD

Thanks for the reply Ben, Logically I had figured out that was the problem, however in this case its aware manipulating 2 fields into one because of the foreign key, so i had a FK on companyId and InvoiceId when aware brings the table invoicedetail in those 2 fields are no longer there and they appear to be replaced by one field which is a reference back to the invoice table.

So because of this do I need to do something else on the DB level outside of aware? I'm not sure... From what I can see in the user guide what I have done should work.