Need Some Input In data Modelling

[abhaysingh]

hi all,

I have one transaction table contain revenue, tax etc with account's detail in it which is in string form..

and one account master with their sub groups like one field Account (Contain String ) and their sub group.

In both transaction and master table Account is common and unique but the prob is values are in String form.. so can i link transaction and Master table with AccountKey??

will it work fine?? format of both transaction and ,master Account field values are Same.

thanks in Advance.

[#2]

Though both the fields have string values, it will work.

[manojkulkarni]

You can make link key on string fields as well provided that has to be unique. It is not necessarily has to be in number, numbers will be faster in sorting/search.

You can even use autonumber function on this field to generate unique number as key.

[timanshu]

Hi,

Yes it will work fine. Format should be proper.

[Anonymous]

Yes it should work fine just check the both column values if they are having same  values or not.

Thanks

BKC