Linked Table Data Not Showing

[goro2010]

Hello Everyone,

I have two tables linked with the same identifier, I use the LogId for the link but my data is not pulling thru as per screenshot below, AssetId is among one of them:

Here is the Table information:

Here is how the tables link:

I have tried to link it with INNER, OUTER and LEFT but no luck, any help would be appricated.

Thanks

[alexandros17]

Everything seems ok, could you please provide the document?

[swuehl]

It seems that your tables are linked by more than 1 common field, you should get notified that a synthetic key has been created during script execution (you will also see the syn key if you switch table viewer to 'internal tables' view).

This might also explain that you don't get a your tables linked like expected.

[goro2010]

Hi,

Only the LogId is a sync key as it should be, print screen is below, I have tried everyting I know to get the data pulled, I have verified that the LogId does exist in both tables.

I am running out of ideas

[swuehl]

I assume above picture shows fields used in a chart object as dimension / fields displayed in list boxes (and I assume above is only a portion of all available fields in your data model).

If so, it might not show the full picture. You need to look at the table viewer to discover synthetic keys.

[goro2010]

Hi,

As per previous requests, please find my entire database..

As you can see there is no sync issues

Anything else I can look at?

[swuehl · Accepted solution]

The tables will only link correctly if you've got matching, identical field values for field LogId in both tables (V_OBJ_Equipment and V_OBJ_Event3), same for TrimDate in tables Calendar and V_OBJ_Event3. Especially for TrimDate, take care that you don't link a timestamp (maybe formatted as date) with a date (i.e. a floating point to an integer).

You can check this by creating a list box with expression num(TrimDate).

[goro2010]

Thanks, the issue was with the dates