Multiple Table Combination in Real Time
Operating system version
Mac OS 10.6.6
Description of the issue
I want to create a table that will create, update, and delete records based on criteria from two tables instantaneously. I need the records in the table to update in real time when the other tables are updated. I've created self-joining relationships with both tables to get the information to another table in real time but I can't figure out how to combine the records from more than one table in real time.
Steps to reproduce the problem
Records from two separate tables can be viewed and looked up from one combined table that is updated in real time.
Can't seem to get the self-joining relationships to accept information from two tables at once.
Exact text of any error message(s) that appear