5 Replies Latest reply on Jun 20, 2011 7:19 AM by techiejw

    Help on Creating Record and Portal Filtering

    techiejw

      Title

      Help on Creating Record and Portal Filtering

      Post

      Hi There - I am creating a database that contains 5 tables: Customer, Class, Students, Class Students and Order.

      The model is as follows: Customers have employees that become students taking our training class. When a customer orders a training class for their employees, the employee is selected. So, in other words, not all employees attend the training class.

      I would like to have the ability to choose the relative employee to company relationship by creating a new record in a portal using based on the class student table.

      As it is now:

      customer->order->class student<-students

      where:

      customer->student

      (arrows indicate primary key to foriegn key)

      Hope this is clear to understand :)

      Help is greatly appreciated!!!