Help on Creating Record and Portal Filtering
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:
(arrows indicate primary key to foriegn key)
Hope this is clear to understand :)
Help is greatly appreciated!!!