Confused on Query's

2007-08-22 Thread Brian E Boothe
lets say u have a table called Parts and another called Projects ,,, how can u associate the Parts Table with the Projects table so lets say u wanna add a Specific Part to a project maybe even add three parts from the parts table and associate it with a specific project ??? so maybe u

Re: Confused on Query's

2007-08-22 Thread Brent Baisley
I assume each part can be associated with multiple projects, which is a many to many relation. In that case you need to create a join table that holds the relation. Table like that are typically just 2 fields, one for the project id and one for the part id. You may want to add other fields