data modeling

[#1]

Dear Friends,

I have Following Issue That is

Transaction Table1:

SubAccount&Product Code as Key

Sub Account,

Company Name,

Product Code,

Date

Transaction Table 2:

SubAccount&Company as Key

Sub Account,

Company Name,

Date

Master:

Sub Account,

Company Name,

Product Code

How do I build Link and Comman calender

[RedSky001]

Your data model looks wrong. 

Please provide some sample real life data in the form of a script with inline statements if you'd like further assistance.

[#3]

hai

Thease are Fields Common Fields Avaliable so how i can go in this case

[RedSky001]

As I wrote in my previous reply

Please provide some sample real life data in the form of a script with inline statements if you'd like further assistance.

[shree909]

try this

Transaction Table1:

//SubAccount&Product Code as Key

Sub Account,

Company Name,

Product Code,

Date

Transaction Table 2:

join(Transaction Table1)

//SubAccount&Company as Key

Sub Account,

Company Name,

Date

Master:

join(Transaction Table1)

Sub Account,

Company Name,

Product Code

then u will get one table with all the values which would be an outer join..

if u provide some examples it will help us

[#6]

this is ok but how i can create common calender

there is no common key in transaction