Search results

Howdie y'all I need a few pointers wrt the relationship between a form and its subform. I have the following form: Top part of the form is for adding/editing etc. The subform is based on a query. The two are linked on the 'week' value. Now, this is what I want to do: The user must not be...

Hello all. Still getting my head around this database stuff, and need some help on defining primary keys and links: Basically, an operating theatre staffing database: It has a four week rolling rota. Lets say for eg there are 10 theatres. Week1 Monday Theatre1(am) will have Surgeon: Joe...

Hello All. I've had a pop at a few databases before, and always regretted not getting the basic structure correct right at the beginning, so I was hoping for some pointers here! Basically, I'm responsible for generating an Operating Theatre staffing rota for a small NHS Hospital. There are 10...

Hello all Firstly, please note I'm an access virgin ;) . I did play with visual dBase a long time ago.... I'm setting up a database for my wife's amateur dramatics company, and am struggling to decide how to arrange the tables and their relationships. This is how the company works. It has...