|
Microsoft Access gimps.
Access.
I have been tasked at work with creating a relational database to log all company equipment in the business (which includes 3 offices and a bucket load of remote users working from home) such as PC's - and all software on that particular PC - Users, Monitors, Printers, Scanners, Docking Ports, etc. And I have to use Microsoft Access. I don't like Access. I'm not that familiar with Access. And like most Microsoft programs, it's full of holes and is rather shit.
So to start things off I needed to create a main form, and I decided to make this based on location; and so, for my primary key I chose 'Location ID' that is automatically generated every time I enter in the location. After that I created all my subforms on to this Location Form - PC details sub-form, User details sub-form, Monitor details sub-form, etc. (all of which had the field 'location ID' in the table so that I could link these sub forms to my main location form's primary key.)
Which is all fine and Dandy. But what I want to start doing now is start linking fields between some of these sub-forms. In particular, the user sub-form. For example, I eventually want PC details to be linked primarily to a location - because this will always be fixed - but also to a user within that location (ie. My user sub-form.) How the FUCK do I do that? I can't seem to create these relationships between sub-forms once the forms have been made. The way I have
Alternatively, it's more than likely I have over complicated things for myself here since I don't have very good knowledge with this program. Is there a better way I could have approached things?
Reading this back, I don't think I could have explained this any worse if I tried. So if I need to elaborate on anything, just ask.
Cheers guys.
|
