View Full Version : Tables refering to more than one table


jobro
11-12-2007, 12:37 AM
So I've been able to link in a table to my orders table. The thing is that my employer needs me to link to two tables. One that holds the tasks that needs to be done. This is completed. Now I need to link the orders table into a version history table with a sub linked table of features related to each version. The problem is that when I link in the version table then when I alter the table and try to access the table view then I can only asign one relation. Is there a way around this?

neileg
11-12-2007, 05:06 AM
Not too clear what you are asking but I'm guessing that you are using a table level lookup. These cause more trouble than they are worth. You should be using a form to enter or view data where you have much more control over things.
You can have a one to many relationship but the lookup doesn't allow you to do that. So you use a form.