Search results

Oh so when we use a foreign key it is not actually repeated? I remember reading in some tutorial that its a pointer to the original table which has the details. Ok so instead of writing the entire details regarding the primary key in the same table and wasting memory we only occupy the memory...

Yeah that seems to be right way to solve the problem.

That seems to be the perfect approach. But I see that there is some redundancy in the orderlines table about orderno getting repeated. Is there any way to remove the redundancy? I thought of normalisation of table but the number of cars may be in hundreds as well as the components that make up...

Ok seems like a similar question is answered earlier. But that still doesn't solve the original problem of how to represent the information or orders and components.

I am beginner student trying learning Access. I am learning Access by doing some simple examples. Suppose I am a car manufacturer. I have a table A in which I write down orders for cars. A record is an order. A single order may contain multiple cars in varying quantities. Each car has its...