I need help with something a little more complicated

[choward]

Hi Guys.

I have 5 tables:

Current Courses
Current Course Demands
Old Course Header
Old Courses
Old Course Demands

Basically - the Current Courses table lists what courses are on this year. The demands are simply another table linked via a one-many relationship (Current Courses -> Current Course Demands) describing how many people from which parts of the country.

Old courses and Old Course demands follow the same pattern - however there is an additional table called Old Course Header which is basically a list of all previous setups used (inactive setups, on a one to many basis of Old Course Header -> Old Courses).

I hope this makes sense so far.

Basically, what i want the user to be able to do is to populate the current courses table (and demands part) with one of the old courses by being able to select which Old Course Header ID from a combo box.

I understand this is a big job - but i'm doing this as a favor to my dad and i dont know Access enough to even know where to start. Any help is appreciated!!

Chris

 

[Simon_MT]

I would be tempted to combine the Old Course information and flag each with type with "C" for Current and "O" for Old. If you want a Course to be current change the flag to "C" or drop a Course change the flag to "O".

Simon

 

[choward]

Thanks Simon,

thats a fantastic idea. I just gave it a quick go - but i'm having trouble editting the Course Details part of the table if it's filtered by whether the header is C or O. It says recordset not updatable - which i assume is because if thedata is via a filtered query, it becomes locked as it's involved in a one to many relationship

Do you know any way around this?

 

[Simon_MT]

1) Which version of Access are you using?
2) Which tables are the Course Details and what are the Unique indexes?

Simon