Displaying details??

[Confused_Case]

Is it possible to do the following?

I have details on a form. As you scroll through the list of different companies, each has different associates and academics etc. When say number 13, joe bloggs company is seleted can u click the academic button to show the acedmics for that specific company? I need this to be done for several different forms, they are all on seperate forms which are linked via command buttons.

 

[ColinEssex]

If you have the companies in one table with an AutoNumber as a unique ID. You then have the associates and academics in another table linked by the same ID number (this is the Foreign Key in the 2nd table)

You can then show them on the same form as the companies in a SubForm, and then as you scroll through, the subform shows the related data.

Col

 

[Confused_Case]

hi mate thanks alot for your help,. really appreciate it! cheers!