Ok, I'm having the following diffuculty. (I'm going to by a book and then QuB to make my life easy but first need to understand this)
I need to make this database.
1. Year (there 6 years with 20 difrent poss.
A. subject + teacher.
a. how many hours a week

How do I avoid that evrything needs to be typed again.
1ste - year - history - 7h - Teacher

O ya I use Nextension and Impakht

What I would recommend is that you sit down, and physically write out what columns you need in each table.

When you have done that, simply work out which columns exist in more than one table.

For every column that exists in 2 different tables, create another table with the common information, and a unique index. Then use the unique index in this column as a pointer in the original tables.

It is really very easy, but often people don't take the simple step of sitting down and working out PRECISELY what information is required.

Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>

It is not the structure that is worry some. but its making the form. To make evry thing work in each table syncrone. Here I am at a los. Its about the last thing I need to learn. Maybe you willing to teach me. Can I contact you?

Hé rawveg thanxs by saying its rely simple. Nextension does a sublime job at what I want do. The only thing I was wrong with was how the relation with prime and foreign key was.
I must look like an utterly fool for you. But when you don't know you don't know.

I mail you an other question about intellicart!