Hard to explain!

[sir_dan_mitchell]

hey brains,

I have a slight problem that if someone could solve I would be overjoyed!!

I am designing a database that currently has 4 tables.

Personnel
Course wanted
Course's avaliable
Course dates

I dont know how relevant that is, but i want to create a form that whereby a user can select personnel, their course and THEN the dates that are available for that specific course!

I currently have a table look up where I can select each of the personnel - this works! Then I also have a very similar function where I can look up each course. The PROBLEM is that I want another value list to appear with the possible dates for that specific course Once its been selected! I think it has something to do with a query but in not sure.

If ur still unsure what I mean...think about when your on a website and your trying to download a driver for your hardware. You select the brand and the a list of possible drivers appear that are relevant to the brand!

I have managed to make all the dates appear in the drop down menu, but as i say I want them to b restricted to the course.

I hope I havent confused you too much,

If there's anything ur unsure of just reply to me

Thanks Dan

 

[eclecticbmxer]

Hi Dan,

I'm fairly new at this, so please don't hold me to this, but I think you are having the same problem I was having the other day.

If you are using multiple combo boxes in one form (and it definitely sounds like you are) you probably want to cascade them.

Although I can't exactly explain what to do, you can search the forums for posts relating to cascading combo boxes. I also found some helpful info at http://support.microsoft.com when i searched for 'synchronizing combo boxes'.

I hope this helps.
Good luck.

 

[sir_dan_mitchell]

hi,

Im afraid its more complicated than that! Im connecting to a SQL so I cant cascade them im afraid!

 

[eclecticbmxer]

Oh, thats beyond my scope...sorry I couldn't help

Good luck though.

 

[Pat Hartman]

Why do you think that connecting to an SQL database is a problem? For most purposes, queries against linked tables operate the same was as queries against local tables.

 

[sir_dan_mitchell]

its not so much of a problem! But i cannot enforce relationships or cascade them etc if the tables are linked to SQL!

 

[Pat Hartman]

Referential integrity is enforced by the database that stores the data. Therefore, if your tables exist in an SQL database, the relationships are defined there using the SQL server tools. No matter what application accesses those tables SQL Server is responsible for maintaining their integrity. If your tables were stored in a DB2 database, DB2 would manage them. If they were stored in an Access database, Jet would manage them.

I think that you are confusing the cascade update/delete operation used by the RDBMS to propagate primary key changes to their respective foreign keys with the synchronization of two combos which is sometimes referred to as cascading.

Look at the last two posts in the following thread to see how to synchronize two combos.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=30894&highlight=combo1