Use Concatenate or Link Table?

[marcohadiyanto]

hi,

i have this table viewer with sync Table and Loop, what should i do? use link table or concatenate?

thanks,

[marcohadiyanto]

hi, thanks for your reply

i know concatenate table but to make link table, i don't know how.

any idea or example?

Marco

[sunil2288]

Hi Macro,

If there are two tables having more than two fields common. Here we can make the two table single but sometimes it really worth to keep the two tables stand alone.

Like Let for a company there are two tables called

Service,Product

Here there is a situation of more than two fields common in both the tables. But it really worthy to keep both the table indivdually stand. To accomplish the lnik between the tables we should create a link table which contain the common fields of both the tables but not creating a synthetic table..

Here we should make the field name using some aliases. and keep the two tables linked .

As we are using the intermediate table for Linking .It is called link table...

Regards,

Sunil