struck in relationships

[tommyried]

Dear All

Please help me on this issue,I have four tables in access one is my main table which is system like for example microsoft,unix etc now i have three more tables under each i have for microsoft different operaitong systems like xp ,windows 7 and in unix i have something like ubuntu etc now what i want to do is i want to create relaitonships between these tables when i click microsoft it should show me all the operating systems in the main table and when i click unix in the same main table it should show me ubuntu.

[Epidural]

When looking at your table, assuming you've used the correct lookup fields and relationships, in your Systems table there should be (+) marks beside each entry; click that plus mark and a dialogue appears. If you've got your relations set up correctly, you should be able to choose to show the OperatingSystems as a subtable according to which OSs have Systems as their parent system. IE If you selected the (+) for Microsoft, it would show a subtable containing Windows 7, Windows XP etc. In the dialogue under your Systems Table, choose your OS table. it should auto-populate the bottom options (IF you've got your relationships correct)

I think that's what you were asking..?

EDIT: Reread your question: the proper relations will be set up automatically if you:
Open your OS table
Go to your OSParentSystem field (or whatever you've named it)
Change the type to Number
Then change the type to "Lookup Field..."
It will prompt you to choose a list: go with a list made from a table or query
Choose your Systems table
Make sure you select ID and an identifying field (such as SystemName or something)
It will show you a preview of the list, accept and finish
Now your OS's ParentSystem field is tied to the ID of the System. Then you can do my above things.

[tommyried]

I am attaching the DB here which consist of four tables subsytem table is my main table i want to create relaiton ship so that when i make dependent combo boxes on a form i should be able to select from one combo box which is subsystem then under another dependent combo box i should be able to select list of other operating systems.

[alansidman]

I think that what you are looking to do are cascading combo boxes in your form. Look at this thread

http://www.access-programmers.co.uk/...d.php?t=223980

[tommyried]

hii again

thanks for ur help regarding cascading combo boxes i got the idea about combo boxes but for relationships i tried to follow the lookup wizard its showing (+) sign for each operating system table but without primary key what iam trying to achieve in my relations is to have a (+) sign in the main subsytem table when iam doing this its telling me to insert subdata sheet , could u please revise my attachment and resend to me by setting proper relationships i will be thankful to u.