Hey guys, I could use some help.

 

I'm setting up a database and I'm a little stuck.  I need to create a database with 90 records (machines), and each of those 90 records need 288 subrecords (positions on machines), and each of those subrecords need another subrecord to display info about said position, and I have no idea how to set this up. Currently I have 3 tables

MACHINE

POSITION

POSITION_CONTROL

I created 288 in the positions tables because theres always 288 positions. 

The user needs to select a machine, then a position on the said machine and then access the control sheet of the said machine on the said position.. Is there any other way to make this work other than creating ~25000 records manually?

Any help whatsoever is appreciated. 

Is there any other way to make this work other than creating ~25000 records manually?

Well, you could mechanize their creation by using a script. That is assuming you really need them - and  I am not entirely convinced you do. There's simply not enough information here about what your solution intends to track, and for what purposes, to express an opinion.