Re: can you help to beginner?

Actually, He should be using three. While one company could use many services, you might also have other companies that offer the same service. So there should be 3 tables to allow a many-to-many relationship. See my e-mail response to him. - Jonathan "Chris Hobbs" <chobbs@silvervalley.k12.ca.us> wrote in message news:3B853E16.1040305@silvervalley.k12.ca.us... > I won't add to the code suggestions already given, but I will share one > thought about your tables - you absolutely _should_ be using two. Any > given company can have from one service to thousands (take GE, > everything from light bulbs to cruise missiles :). The only way to > capture that data effectively is in two tables. > > Andrius Jakutis wrote: > > > > Can you help me? I know that for this example its better to use one table, > > not two, but I am just learning.. > > > -- > Chris Hobbs Silver Valley Unified School District > Head geek: Technology Services Coordinator > webmaster: http://www.silvervalley.k12.ca.us/~chobbs/ > postmaster: chobbs@silvervalley.k12.ca.us >