Relationship

Q:

i,ve set up a simple db for my clients (tax)

3 tables clients,income, expenses. Looks fine on the page.

Did the relationship as per videos. Obviously there is more to

it. They really don’t seem to be related.

A:

Check that the Relationship Builder has selected the correct column from the parent and the child tables to set up the relationship. You can see these by hovering your mouse over the – sign on the relation diagram or by looking at the child Section attributes (Related Data). You can modify the Parent key and Child key attributes if these are not your required values.

A2:

section3(orders) <<-> section1(customers) <->> section2(comments)

section1 is a parent to 2 children.

When you click + to relate sections (=tables), if there are same field names, Lianja will know to relate.
Section1 (customers) and section3 (orders) have the same field CUSTOMERID and will be set automatically.

To relate section1 (customers) and section2 (comments), there are no fields with identical names. you need to set manually for the child section2:

Name:  Screenshot - 14.2.2017. , 20_04_44.png Views: 83 Size:  4.8 KB


 

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.