Jump to content

Search the Community

Showing results for tags 'relatioships'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Caspio Bridge
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


MSN


Website URL


ICQ


Yahoo


Skype


Location


Interests

Found 1 result

  1. Hi guys, Please have a look at the picture it makes it more clear. hopefully someone can help with this simple question. So we have a "Customer" making an "order" this "order" has different "products". So 3 tables. When I connect Customer table to order table, no problem, one customer can have multiple order, when I connect orders to products, I want to be able to chose a customer and only see his orders in the products table. At the moment I can select the customer but I get to see all orders, I want to only see his orders. All this in the table. At the moment it seems that I can just add a product to a customer but the order is not connect to the customer, so when I choose the customers name from my tables drop-down I can still select all the orders, but this is not correct because this customer did NOT make all the orders. This is essentially what I want to do connect products to customers, and customers are connected to orders. That is basically it hopefully I explained myself. well. I included a picture is you look the customer "Tim Sanders" can choose all the orders, but he has NO order so I don't want him to be able to choose an order. Maybe there is a better and easier way to do this please let me know. All suggestions are really welcome. Kind regards, Anthony
×
×
  • Create New...