Tables Relationship

[VikramM1]

Hi, 

I have two table having different fields. Can we create a table relationship for both??

[Dhananjay Pawar]

Hi,

Yes we can create the relationship between those two tables. Parent Child relation we can create by extending the one table to other table.

Let us know if you are looking for different solution.

Thanks,

Dhananjay.

[VikramM1]

Both are having different fields, since, created 2 different tables without extending. Is there any other way other than extending. Because, for that second table i need to create relation ship with other tables also.

when i create relation with first table what ever record created in relationship table that only should store.

when i add it to another table, what ever records created with relation to that table it should store that data itself.

[Dhananjay Pawar]

Hi,

You can create the database views then.

Thanks,

Dhananjay.

[Brad Warman]

If you're using it for reporting, you can use a database view