Jump to content

Need help with setting up relationships


GerthKe

This topic is 3164 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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. 

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 3164 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.