I am unsure what you mean by trying to get your form to "populate" using a button, but have you tried creating a button and seeing what options the wizard offers?
Thanks for your reply Jeremy,
That article was really helpful - I had no idea you could break down tables into so many smaller tables. But I can see why it needs to be done now. I didn't realise that you don't have to have everything you want to display in one report in the same table. Oops...
Thanks very much for your help. I think I see what you are saying - in the maintenance table I should just have fields for the primary keys (motor number and date) and the maintenance performed on each defect. Rather than repeating what the defect was. So, this is what I think I should do...
I am attempting to design a database in access 97 for the first time and have run into some difficulties.
The general idea is that users can report a defect they have discovered and any maintenance they have carried out. These are individual events but in order to report maintenance the user...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.