I have multiple tables that contain tasks according to their category. Each table represents that category. What I need to do is create a 'Master' table that then is able to pull data from ALL the other tables in a dropdown box. For example:
like this, however this is only one table that I'm able to accomplish this from through the use of the 'lookup and relationship' wizard. How do I enable this for data from multiple tables?
Little More Clarification:
Each subtable has a unique 'Task ID':
Category 1 = 1000 series
Category 2 = 2000 series
Category 3 = 3000 series
I need the ability to create unique ID for each of those categories that are then updated, and able to be selected from a different table.