AnsweredAssumed Answered

Help on Creating Record and Portal Filtering

Question asked by techiejw on Jun 16, 2011
Latest reply on Jun 20, 2011 by 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!!!

Outcomes