Recent content by RaiTidR

  1. R

    Table Relationship Confusiong - Linking from one to several.

    Hello Again, I apologize for the late reply Wiklendt as I've been so busy with school, work and family I had to put this on hold. However, with this weekend coming up i'll be able to sink in and try to figure out some of what you have suggested here. I have found that the best thing to do is...
  2. R

    Table Relationship Confusiong - Linking from one to several.

    Thanks again for taking the time to look into it for me wiklendt, if you have the ability and the time great... if not I understand. I don't know what occurred to my first post, I bet I selected to preview post and because I always have so much going on, I just closed the browser assuming it...
  3. R

    Table Relationship Confusiong - Linking from one to several.

    I think maybe my post got eaten... or maybe posts submitted with an attachment require moderation... I wasn't paying so close attention. So I will try again. (I apologize if this winds up being a duplicate thread) --- While trying to follow some of the advice here I messed something up I...
  4. R

    Table Relationship Confusiong - Linking from one to several.

    First let me say... Thank You wiklendt for taking the time to bother with me. It is hard to express via a forum post how much I greatly appreciate it. I usually run into the problem where my ideas are greater than my capacity of understanding for the application. I am going to try out a few...
  5. R

    Table Relationship Confusiong - Linking from one to several.

    The Class Link is actually part of a convenience. Lets pretend I don't ever want to pull up the Class Table... I'll only pull up the Class Form if I have to Add or Delete data (in which case I have 2 forms... 1 specifically for adding classes and 1 fore editing / deleting classes). The concept...
  6. R

    Table Relationship Confusiong - Linking from one to several.

    Ok, I think I understand... but I just want to clarify because I am still trying to figure out the need for certain field. My Assignments Table looks like this: tblAssignments - PKASSIGNMENTSID (autonum) - FKCLASSID (num) - FKTEACHERID (num) - FKASSIGNMENTTYPESID (num) - Assignment Name (txt)...
  7. R

    Table Relationship Confusiong - Linking from one to several.

    So essentially I need to adjust my assignment table to reflect the id from the classes table. - PKASSIGNMENTSID (autonum) - Assignment Type (txt) - FKCLASSID (autonum) - Class Name (txt) - Class Link (link) The only question I have is... what is the purpose of Class ID? The ID number is of no...
  8. R

    Table Relationship Confusiong - Linking from one to several.

    I've read a few thigns online and looked over a few examples but I have to say I'm still vastly confused about relationships. I'm creating a personal project manager of a sorts to keep track of my projects. (Work, School and Misc). So I want to relate the table for classes to the form for...
  9. R

    Field Addition Complication

    I did... and by every standard of math i know it doesn't seem to calculate anything. I looked in design view of the form... but since I couldn't tell what was supposed to be calculated and what wasn't I really couldn't decipher it. Furthermore, I don't know if it was intentional but on my...
  10. R

    Field Addition Complication

    I'm slightly confused as to what field these codes would go in. TOTAL: NZ([ONE])+NZ([TWO])+NZ([THREE])+NZ([FOUR]) Should it be like the following TOTAL: NZ([FIELDVALUE01])+NZ([FIELDVALUE02]) Am I understanding this correctly. --- Edit: Ok I tried this... don't know if this was right. It...
  11. R

    Field Addition Complication

    I don't understand? --- I initially made the form as only a Customer Contract database. A Simple data entry type of document that would allow us to have a digital file of existing contracts. However, my boss was so impressed with how clean the design was that he wanted me to explore the...
  12. R

    Field Addition Complication

    Hello again... I got almost everything working on the form except for the Grand Total feature. I tried the =[field1]+[field2]+[field3]+[field4]+[field5]+[field6]+[field7] and so on and so forth to the point it would add all the fields up into a grand total. The only problem I run into is it...
  13. R

    Contractor's Estimate Form

    So you want .5 on both sides... SO make it not exceed 7.5 inches... alright man thanks a lot. I'll test it out later today and see if I can make it stop prining those 2 blank pages.
  14. R

    Contractor's Estimate Form

    SUCCESS!!! Thanks a Million Mr. Hartman... I've had this form for 9 months now created... and couldn't do a damn thing with it. My boss so frustrated about finding a solution for estimates (turned contract) to be legible say... pay whatever its going to take to get this working. --- Thanks...
  15. R

    Contractor's Estimate Form

    OK... i remember trying with expressions before and I couldn't quite get it to work. So I'm going to try it now and see what I can come up with. (In response to the Width) I have tinkered with the width many times... compressing the information on the page to almost 7 inches (and in spite of...
Back
Top Bottom