This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

DEVELOPERS FORUM - Data Type Suggestion

divya_p02 - Tuesday, June 28, 2011 7:26 AM:

Hi

I have two tables

Table 1 : Activity (Itemtype) where id is the primary key

Table 2 : Temporary(Itemtype) where id is the primary key

Requiremnt is

i want id of Table 1 (Activity) table to be referenced in Table 2 as a column and the column should be having id's of table 1

Example : Sample Table 1 Data

id                                                 Name

32bit integer                             Activity 1

Sample Table 2 Data

id                                                  Name                             Activity Id

32bit integer                              Temp Name                 32 bit Integer of Table 1

 

Please let me know approaches to acheive the same. My approaches are not able to fill the data in table 2 for Activity Id column, its getting null values. Reply soon as its very critical to proceed further.

Regards

Divya



fli - Thursday, June 30, 2011 9:47 AM:

Hi Divya,

The Activity could be a "rel to non" then having the Temp id as it's "source_id"

else maybe use a federated datatype property on the Temp Itemtype.

how shall this work ?

BR / Christoffer