Search results

The database works the other way around as you have stated, one Customer can have/be associated with many Properties, or many Properties can fall under one Contract. Does this help? John

jdraw, Yes your assumption is correct. For example, given record in the tblProperty table may not have a “Property Type” so the corresponding PropertyTypeID FK in the tblProperty table would be blank. Having said this back to my original issue, when I created the query any record with any...

Bryan, Let me clarify the way I setup this database. Referencing the Relationship image from the post above, with the exception of the tblAudit table all of the others represent a list of option available to the user. And that selection is associated to the tblProperty table via the one-to-many...

Yes I do (see attached Relationship).... If this not correct please let me know and could you provide a referance that i can read to obtain the correct process.... John

I have a table “tblProperty” with multiple fields; some text and some number fields along with number fields representing FK, the number fields are things like “pages” and “copies”. I have created a query containing the table described above and the associated tables for each FK. When I drop...

jz, Yes, I can receive a USPS Express containing one or more pieces of material (e.g. CD/DVD’s, Documents ECT) in any combination. The same is true if I am sending material. Not to put a monkey wrench into this but, I could receive a given piece of material on one day and send the same piece...

Jz, Thanks for your advice, I agree with your assessment of the tblSentDetails and tblReceivedDetails and have combined them see Relationship2 image showing related tables. However I did leave the organization and carrier tables separate, I did rename the carrier to mailcarrier. The reason being...

I have an issue with getting an unbound combo box in a form to do what I want. I have originally posted in the Modules & VBA thread but have not gotten any “hits”. Below is the link to that post with details. http://www.access-programmers.co.uk/forums/showthread.php?t=227618 Thanks John

Hello All, I have an issue I am trying to resolve, I have a possible method to resolve this issue but I need help with the possible code. Also, if there is a better way to go about solving the issue please let me know. Background: I am using Access 2007; if you look at the attached Relationship...

Pat, Attached is relationship #4 and I have included the section from the FAR clause that identifies the minimum information required to be maintained by the property manager. As per you advice I have put all of the things I believe belong with the PropertyDetail table I have renamed a couple...

All, Sorry about not being able to upload the original database. I can send it via email if you are interested. Also attached is the .pdf of my second pass at normalizing. John

All, As stated above attached is the working Government Property database. There are parts of the database I did not talk about before, like the Audit part. There is a requirement to maintain audit history. The way I have implemented the auditing is as follows: Create an audit form by...

Pat, If you think it would help, I actually have a working Government Furnished Equipment database now. I created this database before I started taking a hard look at database development (outside of Access). This database was created before I started looking into Normal Forms and normalization...

Thanks All, I am sorry for any “face planting” done on my behalf. To answer a top level question, yes it is a complex and convoluted process. Part of the problem is I am dealing with the government and some of their processes don’t lend themselves to straight forward answers. I will try to...

Spike, No problem, sometimes it is difficult to remember not everyone knows what you do on a given subject. Government Furnish Equipment/Property (GFE/P) is a term used to identify equipment and/or property obtained either directly by signed receipt or indirectly by ordering the item using...

Pat/Spike, I have made some changes to the structure as you pointed out. I will have to think a bit more about the Contracts and Customer issue. I agree the name “Master” was misleading, I have changed it to “Item” and I have merged the old items table into the new re-named “Item” table...

Spike, Sorry for the lack of information, see the .jpg below. I have changed some of the row information to make it flow better. The ProtoType table is there to provide a predetermined list of property types. The ItemLocation table is the physical location of the item. The Customer table is a...

Hello All, Not sure if this belongs here or in the Theories thread. Need some help/advice on the Normal Form/Normalization process as it relates to the tables shown in the .pdf below. I believe I have it down pretty good (I may be wrong); there are two things I need help with. First in the...

Thanks Pat, I was able to do as you sugjested, i did end up making select querys for the problem children on my form. I am using Acess 2007 and it does seem to be buggy at times... Thanks again John

If it helps attached is my current Relationship screen. You can see i have the tblOrganizatio and the _1 and _2. John